DBA Data[Home] [Help]

APPS.IBU_ALERT_BIN dependencies on FND_USER

Line 76: l_employee_id fnd_user.employee_id%TYPE;

72: resource_id NUMBER;
73: newln VARCHAR2(2) := fnd_global.newline();
74: no_items_fnd VARCHAR2(1000);
75:
76: l_employee_id fnd_user.employee_id%TYPE;
77: l_customer_id fnd_user.customer_id%TYPE;
78: l_supplier_id fnd_user.supplier_id%TYPE;
79:
80: begin

Line 77: l_customer_id fnd_user.customer_id%TYPE;

73: newln VARCHAR2(2) := fnd_global.newline();
74: no_items_fnd VARCHAR2(1000);
75:
76: l_employee_id fnd_user.employee_id%TYPE;
77: l_customer_id fnd_user.customer_id%TYPE;
78: l_supplier_id fnd_user.supplier_id%TYPE;
79:
80: begin
81: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 78: l_supplier_id fnd_user.supplier_id%TYPE;

74: no_items_fnd VARCHAR2(1000);
75:
76: l_employee_id fnd_user.employee_id%TYPE;
77: l_customer_id fnd_user.customer_id%TYPE;
78: l_supplier_id fnd_user.supplier_id%TYPE;
79:
80: begin
81: -- Initialize message list if p_init_msg_list is set to TRUE.
82: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 125: from fnd_user

121: begin
122: -- to be patched
123: select employee_id, customer_id, supplier_id
124: into l_employee_id, l_customer_id, l_supplier_id
125: from fnd_user
126: Where user_id = p_user_id;
127:
128: If (l_employee_id is not null ) Then
129: select resource_id

Line 131: from jtf_rs_resource_extns a, fnd_user b

127:
128: If (l_employee_id is not null ) Then
129: select resource_id
130: into resource_id
131: from jtf_rs_resource_extns a, fnd_user b
132: where a.source_id = b.employee_id
133: and a.category = 'EMPLOYEE'
134: and b.user_id = p_user_id
135: and ( (a.end_date_active is null ) Or (a.end_date_active > sysdate) );

Line 139: from jtf_rs_resource_extns a, fnd_user b

135: and ( (a.end_date_active is null ) Or (a.end_date_active > sysdate) );
136: Elsif (l_customer_id is not null )Then
137: select resource_id
138: into resource_id
139: from jtf_rs_resource_extns a, fnd_user b
140: where a.source_id = b.customer_id
141: and a.category = 'PARTY'
142: and b.user_id = p_user_id
143: and ( (a.end_date_active is null ) Or (a.end_date_active > sysdate) );

Line 147: from jtf_rs_resource_extns a, fnd_user b

143: and ( (a.end_date_active is null ) Or (a.end_date_active > sysdate) );
144: ElsIf (l_supplier_id is not null )Then
145: select resource_id
146: into resource_id
147: from jtf_rs_resource_extns a, fnd_user b
148: where a.source_id = b.supplier_id
149: and a.category = 'SUPPLIER_CONTACT'
150: and b.user_id = p_user_id
151: and ( (a.end_date_active is null ) Or (a.end_date_active > sysdate) );

Line 310: l_employee_id fnd_user.employee_id%TYPE;

306: item_persp_array AMV_ITEM_PUB.AMV_NAMEID_VARRAY_TYPE;
307: item_author_array AMV_ITEM_PUB.AMV_CHAR_VARRAY_TYPE;
308: item_keyword_array AMV_ITEM_PUB.AMV_CHAR_VARRAY_TYPE;
309:
310: l_employee_id fnd_user.employee_id%TYPE;
311: l_customer_id fnd_user.customer_id%TYPE;
312: l_supplier_id fnd_user.supplier_id%TYPE;
313:
314: begin

Line 311: l_customer_id fnd_user.customer_id%TYPE;

307: item_author_array AMV_ITEM_PUB.AMV_CHAR_VARRAY_TYPE;
308: item_keyword_array AMV_ITEM_PUB.AMV_CHAR_VARRAY_TYPE;
309:
310: l_employee_id fnd_user.employee_id%TYPE;
311: l_customer_id fnd_user.customer_id%TYPE;
312: l_supplier_id fnd_user.supplier_id%TYPE;
313:
314: begin
315:

Line 312: l_supplier_id fnd_user.supplier_id%TYPE;

308: item_keyword_array AMV_ITEM_PUB.AMV_CHAR_VARRAY_TYPE;
309:
310: l_employee_id fnd_user.employee_id%TYPE;
311: l_customer_id fnd_user.customer_id%TYPE;
312: l_supplier_id fnd_user.supplier_id%TYPE;
313:
314: begin
315:
316: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 496: from fnd_user

492: begin
493: -- to be patched
494: select employee_id, customer_id, supplier_id
495: into l_employee_id, l_customer_id, l_supplier_id
496: from fnd_user
497: Where user_id = l_user_id;
498:
499: If (l_employee_id is not null ) Then
500: select resource_id

Line 502: from jtf_rs_resource_extns a, fnd_user b

498:
499: If (l_employee_id is not null ) Then
500: select resource_id
501: into resource_id
502: from jtf_rs_resource_extns a, fnd_user b
503: where a.source_id = b.employee_id
504: and a.category = 'EMPLOYEE'
505: and b.user_id = l_user_id
506: and ( (a.end_date_active is null ) Or (a.end_date_active > sysdate) );

Line 510: from jtf_rs_resource_extns a, fnd_user b

506: and ( (a.end_date_active is null ) Or (a.end_date_active > sysdate) );
507: Elsif (l_customer_id is not null )Then
508: select resource_id
509: into resource_id
510: from jtf_rs_resource_extns a, fnd_user b
511: where a.source_id = b.customer_id
512: and a.category = 'PARTY'
513: and b.user_id = l_user_id
514: and ( (a.end_date_active is null ) Or (a.end_date_active > sysdate) );

Line 518: from jtf_rs_resource_extns a, fnd_user b

514: and ( (a.end_date_active is null ) Or (a.end_date_active > sysdate) );
515: ElsIf (l_supplier_id is not null )Then
516: select resource_id
517: into resource_id
518: from jtf_rs_resource_extns a, fnd_user b
519: where a.source_id = b.supplier_id
520: and a.category = 'SUPPLIER_CONTACT'
521: and b.user_id = l_user_id
522: and ( (a.end_date_active is null ) Or (a.end_date_active > sysdate) );