APPS.CSL_NOTIFICATIONS_PKG dependencies on FND_USER

Line 33: CURSOR c_fnd_user

29: p_record IN c_notification%ROWTYPE,
30: p_error_msg OUT NOCOPY VARCHAR2,
31: x_return_status IN OUT NOCOPY VARCHAR2
32: ) IS
33: CURSOR c_fnd_user
34: ( b_user_name fnd_user.user_name%TYPE
35: )
36: IS
37: SELECT fu.user_name

Line 34: ( b_user_name fnd_user.user_name%TYPE

30: p_error_msg OUT NOCOPY VARCHAR2,
31: x_return_status IN OUT NOCOPY VARCHAR2
32: ) IS
33: CURSOR c_fnd_user
34: ( b_user_name fnd_user.user_name%TYPE
35: )
36: IS
37: SELECT fu.user_name
38: , fu.start_date

Line 40: FROM fnd_user fu

36: IS
37: SELECT fu.user_name
38: , fu.start_date
39: , fu.end_date
40: FROM fnd_user fu
41: WHERE fu.user_name = b_user_name;
42:
43: r_fnd_user c_fnd_user%ROWTYPE;
44:

Line 43: r_fnd_user c_fnd_user%ROWTYPE;

39: , fu.end_date
40: FROM fnd_user fu
41: WHERE fu.user_name = b_user_name;
42:
43: r_fnd_user c_fnd_user%ROWTYPE;
44:
45: CURSOR c_attr( b_notification_id NUMBER, b_name VARCHAR2 ) IS
46: SELECT *
47: FROM WF_NOTIFICATION_ATTRIBUTES

Line 72: OPEN c_fnd_user( b_user_name => p_record.recipient_role );

68:
69: l_receiver_found := FALSE;
70: l_valid_receiver := FALSE;
71: -- Check if receiver exists
72: OPEN c_fnd_user( b_user_name => p_record.recipient_role );
73: FETCH c_fnd_user INTO r_fnd_user;
74: IF c_fnd_user%FOUND THEN
75: l_receiver_found := TRUE;
76: ELSE

Line 73: FETCH c_fnd_user INTO r_fnd_user;

69: l_receiver_found := FALSE;
70: l_valid_receiver := FALSE;
71: -- Check if receiver exists
72: OPEN c_fnd_user( b_user_name => p_record.recipient_role );
73: FETCH c_fnd_user INTO r_fnd_user;
74: IF c_fnd_user%FOUND THEN
75: l_receiver_found := TRUE;
76: ELSE
77: l_receiver_found := FALSE;

Line 74: IF c_fnd_user%FOUND THEN

70: l_valid_receiver := FALSE;
71: -- Check if receiver exists
72: OPEN c_fnd_user( b_user_name => p_record.recipient_role );
73: FETCH c_fnd_user INTO r_fnd_user;
74: IF c_fnd_user%FOUND THEN
75: l_receiver_found := TRUE;
76: ELSE
77: l_receiver_found := FALSE;
78: END IF;

Line 79: CLOSE c_fnd_user;

75: l_receiver_found := TRUE;
76: ELSE
77: l_receiver_found := FALSE;
78: END IF;
79: CLOSE c_fnd_user;
80:
81: IF l_receiver_found THEN
82: -- Check if receiver is valid for the current date
83: IF TRUNC(r_fnd_user.start_date) > TRUNC(SYSDATE) THEN

Line 83: IF TRUNC(r_fnd_user.start_date) > TRUNC(SYSDATE) THEN

79: CLOSE c_fnd_user;
80:
81: IF l_receiver_found THEN
82: -- Check if receiver is valid for the current date
83: IF TRUNC(r_fnd_user.start_date) > TRUNC(SYSDATE) THEN
84: -- The receiver is not yet valid
85: x_return_status := FND_API.G_RET_STS_ERROR;
86: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
87: ( p_message => 'CSL_MAIL_RECEIVER_NOT_YET'

Line 91: , p_token_value2 => FND_DATE.Date_To_CharDT(r_fnd_user.start_date)

87: ( p_message => 'CSL_MAIL_RECEIVER_NOT_YET'
88: , p_token_name1 => 'MAIL_RECEIVER'
89: , p_token_value1 => p_record.recipient_role
90: , p_token_name2 => 'START_DATE'
91: , p_token_value2 => FND_DATE.Date_To_CharDT(r_fnd_user.start_date)
92: );
93: ELSIF TRUNC(r_fnd_user.end_date) < TRUNC(SYSDATE)
94: THEN
95: -- The receiver is no longer valid

Line 93: ELSIF TRUNC(r_fnd_user.end_date) < TRUNC(SYSDATE)

89: , p_token_value1 => p_record.recipient_role
90: , p_token_name2 => 'START_DATE'
91: , p_token_value2 => FND_DATE.Date_To_CharDT(r_fnd_user.start_date)
92: );
93: ELSIF TRUNC(r_fnd_user.end_date) < TRUNC(SYSDATE)
94: THEN
95: -- The receiver is no longer valid
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 102: , p_token_value2 => FND_DATE.Date_To_CharDT(r_fnd_user.end_date)

98: ( p_message => 'CSL_MAIL_RECEIVER_OUTDATED'
99: , p_token_name1 => 'MAIL_RECEIVER'
100: , p_token_value1 => p_record.recipient_role
101: , p_token_name2 => 'END_DATE'
102: , p_token_value2 => FND_DATE.Date_To_CharDT(r_fnd_user.end_date)
103: );
104: ELSE
105: -- The receiver is valid
106: l_valid_receiver := TRUE;