APPS.IBE_PROD_RELATION_PVT dependencies on FND_GLOBAL

Line 20: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;

16: )
17: IS
18: L_API_NAME CONSTANT VARCHAR2(30) := 'Insert_Relationship';
19: L_API_VERSION CONSTANT NUMBER := 1.0;
20: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;
21: l_rowid VARCHAR2(30);
22: l_debug VARCHAR2(1);
23:
24: BEGIN

Line 86: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

82: X_CREATION_DATE => sysdate,
83: X_CREATED_BY => l_user_id,
84: X_LAST_UPDATE_DATE => sysdate,
85: X_LAST_UPDATED_BY => l_user_id,
86: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
87: );
88:
89: EXCEPTION
90: WHEN NO_DATA_FOUND THEN

Line 171: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;

167: )
168: IS
169: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Relationship';
170: L_API_VERSION CONSTANT NUMBER := 1.0;
171: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;
172: i PLS_INTEGER;
173: l_debug VARCHAR2(1);
174:
175: BEGIN

Line 233: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

229: X_MEANING => p_rel_type_code,
230: X_DESCRIPTION => p_description,
231: X_LAST_UPDATE_DATE => sysdate,
232: X_LAST_UPDATED_BY => l_user_id,
233: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
234: );
235: EXCEPTION
236: WHEN NO_DATA_FOUND THEN
237: IF (l_debug = 'Y') THEN

Line 318: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;

314: )
315: IS
316: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Relationship_Detail';
317: L_API_VERSION CONSTANT NUMBER := 1.0;
318: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;
319: i PLS_INTEGER;
320: l_debug VARCHAR2(1);
321:
322: BEGIN

Line 380: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

376: X_MEANING => p_meaning,
377: X_DESCRIPTION => p_description,
378: X_LAST_UPDATE_DATE => sysdate,
379: X_LAST_UPDATED_BY => l_user_id,
380: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
381: );
382: EXCEPTION
383: WHEN NO_DATA_FOUND THEN
384: IF (l_debug = 'Y') THEN

Line 611: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;

607: )
608: IS
609: L_API_NAME CONSTANT VARCHAR2(30) := 'Exclude_Related_Items';
610: L_API_VERSION CONSTANT NUMBER := 1.0;
611: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;
612: l_debug VARCHAR2(1);
613:
614: BEGIN
615: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');

Line 710: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;

706: )
707: IS
708: L_API_NAME CONSTANT VARCHAR2(30) := 'Include_Related_Items';
709: L_API_VERSION CONSTANT NUMBER := 1.0;
710: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;
711: l_debug VARCHAR2(1);
712:
713: BEGIN
714: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');

Line 825: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;

821: p_dest_object_id IN NUMBER ,
822: p_organization_id IN NUMBER
823: )
824: IS
825: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;
826: l_category_set_id_str VARCHAR2(30);
827: l_debug VARCHAR2(1);
828:
829: BEGIN

Line 998: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;

994: l_rel_rule_id NUMBER(15);
995: l_rel_type_code VARCHAR2(30);
996: l_object_type VARCHAR2(30);
997: l_object_id NUMBER(15);
998: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;
999: BEGIN
1000: -- 1. Where Category p_category_id is origin
1001: OPEN l_rel_rule_csr FOR 'SELECT relation_type_code, relation_rule_id, dest_object_type, dest_object_id ' ||
1002: 'FROM ibe_ct_relation_rules ' ||

Line 1076: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;

1072: l_rel_rule_id NUMBER(15);
1073: l_rel_type_code VARCHAR2(30);
1074: l_object_type VARCHAR2(30);
1075: l_object_id NUMBER(15);
1076: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;
1077: BEGIN
1078: -- 1. Where Section p_section_id is origin
1079: OPEN l_rel_rule_csr FOR 'SELECT relation_type_code, relation_rule_id, dest_object_type, dest_object_id ' ||
1080: 'FROM ibe_ct_relation_rules ' ||