APPS.IBW_REFERRAL_PVT dependencies on IBW_REFERRAL_CATEGORIES_B

Line 16: -- Offline engine uses this API to insert records into IBW_REFERRAL_CATEGORIES_B, IBW_REFERRAL_CATEGORIES_TL,

12: -- PURPOSE
13: -- Private API for inserting records into referral categories and also referral patterns. Mainly used by offline engine
14: --
15: -- NOTES
16: -- Offline engine uses this API to insert records into IBW_REFERRAL_CATEGORIES_B, IBW_REFERRAL_CATEGORIES_TL,
17: -- IBW_REFERRAL_PATTERNS_B, IBW_REFERRAL_PATTERNS_TL
18:
19: -- HISTORY
20: -- 05/10/2005 VEKANCHA Created

Line 64: CURSOR c IS SELECT ibw_referral_categories_b_s1.nextval FROM dual;

60: program_login_id NUMBER;
61: program_app_id NUMBER;
62: request_id NUMBER;
63:
64: CURSOR c IS SELECT ibw_referral_categories_b_s1.nextval FROM dual;
65:
66: CURSOR c1 IS SELECT ibw_url_patterns_b_s1.nextval FROM dual;
67:
68: CURSOR c2 IS SELECT referral_category_id FROM ibw_referral_categories_b

Line 68: CURSOR c2 IS SELECT referral_category_id FROM ibw_referral_categories_b

64: CURSOR c IS SELECT ibw_referral_categories_b_s1.nextval FROM dual;
65:
66: CURSOR c1 IS SELECT ibw_url_patterns_b_s1.nextval FROM dual;
67:
68: CURSOR c2 IS SELECT referral_category_id FROM ibw_referral_categories_b
69: WHERE referral_category_id = x_ref_cat_id;
70:
71: BEGIN
72: x_status := 'Y';

Line 101: INSERT INTO ibw_referral_categories_b (referral_category_id, status, user_defined_flag, created_by, creation_date,

97: FND_PROFILE.GET('CONC_PROGRAM_APPLICATION_ID', program_app_id);
98:
99: FND_PROFILE.GET('CONC_REQUEST_ID', request_id);
100:
101: INSERT INTO ibw_referral_categories_b (referral_category_id, status, user_defined_flag, created_by, creation_date,
102: last_updated_by, last_update_date, last_update_login, object_version_number,
103: program_id, program_login_id, program_application_id, request_id)
104: VALUES (x_ref_cat_id, x_status, x_user_def_flag, created_by, creation_date,
105: last_updated_by, last_update_date, last_update_login, obj_ver_number,

Line 114: FROM ibw_referral_categories_b M, fnd_languages l, fnd_languages b

110: program_id, program_login_id, program_application_id, request_id)
111: SELECT M.referral_category_id, l.language_code, b.language_code, x_referral_category_name, NULL, M.created_by, M.creation_date,
112: M.last_updated_by, M.last_update_date, M.last_update_login, M.object_version_number,
113: M.program_id, M.program_login_id, M.program_application_id, M.request_id
114: FROM ibw_referral_categories_b M, fnd_languages l, fnd_languages b
115: WHERE l.installed_flag IN ('I','B') AND b.installed_flag='B' AND M.referral_category_id=x_ref_cat_id;
116:
117:
118: INSERT INTO ibw_url_patterns_b (url_pattern_id, url_pattern, type_id, type, created_by, creation_date,

Line 155: from IBW_REFERRAL_CATEGORIES_B B

151: begin
152: delete from IBW_REFERRAL_CATEGORIES_TL T
153: where not exists
154: (select NULL
155: from IBW_REFERRAL_CATEGORIES_B B
156: where B.REFERRAL_CATEGORY_ID = T.REFERRAL_CATEGORY_ID
157: );
158:
159: update IBW_REFERRAL_CATEGORIES_TL T set (