DBA Data[Home] [Help]

APPS.IBE_SEARCH_PVT dependencies on FND_GLOBAL

Line 101: 0, FND_GLOBAL.user_id,

97: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
98: , CATEGORY_SET_ID, WEB_STATUS)
99: SELECT
100: ibe_ct_imedia_search_s1.nextval,
101: 0, FND_GLOBAL.user_id,
102: SYSDATE, FND_GLOBAL.user_id,
103: SYSDATE, FND_GLOBAL.conc_login_id,
104: new_category_id , new_organization_id ,
105: new_inventory_item_id, b.LANGUAGE,

Line 102: SYSDATE, FND_GLOBAL.user_id,

98: , CATEGORY_SET_ID, WEB_STATUS)
99: SELECT
100: ibe_ct_imedia_search_s1.nextval,
101: 0, FND_GLOBAL.user_id,
102: SYSDATE, FND_GLOBAL.user_id,
103: SYSDATE, FND_GLOBAL.conc_login_id,
104: new_category_id , new_organization_id ,
105: new_inventory_item_id, b.LANGUAGE,
106: b.DESCRIPTION, b.LONG_DESCRIPTION,

Line 103: SYSDATE, FND_GLOBAL.conc_login_id,

99: SELECT
100: ibe_ct_imedia_search_s1.nextval,
101: 0, FND_GLOBAL.user_id,
102: SYSDATE, FND_GLOBAL.user_id,
103: SYSDATE, FND_GLOBAL.conc_login_id,
104: new_category_id , new_organization_id ,
105: new_inventory_item_id, b.LANGUAGE,
106: b.DESCRIPTION, b.LONG_DESCRIPTION,
107: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,c.concatenated_segments),

Line 129: 0, FND_GLOBAL.user_id,

125: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
126: , CATEGORY_SET_ID, WEB_STATUS)
127: SELECT
128: ibe_ct_imedia_search_s1.nextval,
129: 0, FND_GLOBAL.user_id,
130: SYSDATE, FND_GLOBAL.user_id,
131: SYSDATE, FND_GLOBAL.conc_login_id,
132: new_category_id , new_organization_id ,
133: new_inventory_item_id, b.LANGUAGE,

Line 130: SYSDATE, FND_GLOBAL.user_id,

126: , CATEGORY_SET_ID, WEB_STATUS)
127: SELECT
128: ibe_ct_imedia_search_s1.nextval,
129: 0, FND_GLOBAL.user_id,
130: SYSDATE, FND_GLOBAL.user_id,
131: SYSDATE, FND_GLOBAL.conc_login_id,
132: new_category_id , new_organization_id ,
133: new_inventory_item_id, b.LANGUAGE,
134: b.DESCRIPTION, b.LONG_DESCRIPTION,

Line 131: SYSDATE, FND_GLOBAL.conc_login_id,

127: SELECT
128: ibe_ct_imedia_search_s1.nextval,
129: 0, FND_GLOBAL.user_id,
130: SYSDATE, FND_GLOBAL.user_id,
131: SYSDATE, FND_GLOBAL.conc_login_id,
132: new_category_id , new_organization_id ,
133: new_inventory_item_id, b.LANGUAGE,
134: b.DESCRIPTION, b.LONG_DESCRIPTION,
135: ibe_search_setup_pvt.WriteToLob(b.description, b.long_description ,c.concatenated_segments),

Line 155: 0, FND_GLOBAL.user_id,

151: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
152: , CATEGORY_SET_ID, WEB_STATUS)
153: SELECT
154: ibe_ct_imedia_search_s1.nextval,
155: 0, FND_GLOBAL.user_id,
156: SYSDATE, FND_GLOBAL.user_id,
157: SYSDATE, FND_GLOBAL.conc_login_id,
158: new_category_id , new_organization_id ,
159: new_inventory_item_id, b.LANGUAGE,

Line 156: SYSDATE, FND_GLOBAL.user_id,

152: , CATEGORY_SET_ID, WEB_STATUS)
153: SELECT
154: ibe_ct_imedia_search_s1.nextval,
155: 0, FND_GLOBAL.user_id,
156: SYSDATE, FND_GLOBAL.user_id,
157: SYSDATE, FND_GLOBAL.conc_login_id,
158: new_category_id , new_organization_id ,
159: new_inventory_item_id, b.LANGUAGE,
160: b.DESCRIPTION, b.LONG_DESCRIPTION,

Line 157: SYSDATE, FND_GLOBAL.conc_login_id,

153: SELECT
154: ibe_ct_imedia_search_s1.nextval,
155: 0, FND_GLOBAL.user_id,
156: SYSDATE, FND_GLOBAL.user_id,
157: SYSDATE, FND_GLOBAL.conc_login_id,
158: new_category_id , new_organization_id ,
159: new_inventory_item_id, b.LANGUAGE,
160: b.DESCRIPTION, b.LONG_DESCRIPTION,
161: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,c.concatenated_segments),

Line 345: 0, FND_GLOBAL.user_id,

341: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
342: , CATEGORY_SET_ID, WEB_STATUS)
343: SELECT
344: ibe_ct_imedia_search_s1.nextval,
345: 0, FND_GLOBAL.user_id,
346: SYSDATE, FND_GLOBAL.user_id,
347: SYSDATE, FND_GLOBAL.conc_login_id,
348: new_category_id , new_organization_id ,
349: new_inventory_item_id, b.LANGUAGE,

Line 346: SYSDATE, FND_GLOBAL.user_id,

342: , CATEGORY_SET_ID, WEB_STATUS)
343: SELECT
344: ibe_ct_imedia_search_s1.nextval,
345: 0, FND_GLOBAL.user_id,
346: SYSDATE, FND_GLOBAL.user_id,
347: SYSDATE, FND_GLOBAL.conc_login_id,
348: new_category_id , new_organization_id ,
349: new_inventory_item_id, b.LANGUAGE,
350: b.DESCRIPTION, b.LONG_DESCRIPTION,

Line 347: SYSDATE, FND_GLOBAL.conc_login_id,

343: SELECT
344: ibe_ct_imedia_search_s1.nextval,
345: 0, FND_GLOBAL.user_id,
346: SYSDATE, FND_GLOBAL.user_id,
347: SYSDATE, FND_GLOBAL.conc_login_id,
348: new_category_id , new_organization_id ,
349: new_inventory_item_id, b.LANGUAGE,
350: b.DESCRIPTION, b.LONG_DESCRIPTION,
351: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,c.concatenated_segments),

Line 482: 0, FND_GLOBAL.user_id,

478: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
479: , CATEGORY_SET_ID, WEB_STATUS)
480: SELECT
481: ibe_ct_imedia_search_s1.nextval,
482: 0, FND_GLOBAL.user_id,
483: SYSDATE, FND_GLOBAL.user_id,
484: SYSDATE, FND_GLOBAL.conc_login_id,
485: d.category_id , old_organization_id ,
486: old_inventory_item_id, b.LANGUAGE,

Line 483: SYSDATE, FND_GLOBAL.user_id,

479: , CATEGORY_SET_ID, WEB_STATUS)
480: SELECT
481: ibe_ct_imedia_search_s1.nextval,
482: 0, FND_GLOBAL.user_id,
483: SYSDATE, FND_GLOBAL.user_id,
484: SYSDATE, FND_GLOBAL.conc_login_id,
485: d.category_id , old_organization_id ,
486: old_inventory_item_id, b.LANGUAGE,
487: b.DESCRIPTION, b.LONG_DESCRIPTION,

Line 484: SYSDATE, FND_GLOBAL.conc_login_id,

480: SELECT
481: ibe_ct_imedia_search_s1.nextval,
482: 0, FND_GLOBAL.user_id,
483: SYSDATE, FND_GLOBAL.user_id,
484: SYSDATE, FND_GLOBAL.conc_login_id,
485: d.category_id , old_organization_id ,
486: old_inventory_item_id, b.LANGUAGE,
487: b.DESCRIPTION, b.LONG_DESCRIPTION,
488: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,a.concatenated_segments),

Line 538: 0, FND_GLOBAL.user_id,

534: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
535: , CATEGORY_SET_ID, WEB_STATUS)
536: SELECT
537: ibe_ct_imedia_search_s1.nextval,
538: 0, FND_GLOBAL.user_id,
539: SYSDATE, FND_GLOBAL.user_id,
540: SYSDATE, FND_GLOBAL.conc_login_id,
541: d.category_id , old_organization_id ,
542: old_inventory_item_id, b.LANGUAGE,

Line 539: SYSDATE, FND_GLOBAL.user_id,

535: , CATEGORY_SET_ID, WEB_STATUS)
536: SELECT
537: ibe_ct_imedia_search_s1.nextval,
538: 0, FND_GLOBAL.user_id,
539: SYSDATE, FND_GLOBAL.user_id,
540: SYSDATE, FND_GLOBAL.conc_login_id,
541: d.category_id , old_organization_id ,
542: old_inventory_item_id, b.LANGUAGE,
543: b.DESCRIPTION, b.LONG_DESCRIPTION,

Line 540: SYSDATE, FND_GLOBAL.conc_login_id,

536: SELECT
537: ibe_ct_imedia_search_s1.nextval,
538: 0, FND_GLOBAL.user_id,
539: SYSDATE, FND_GLOBAL.user_id,
540: SYSDATE, FND_GLOBAL.conc_login_id,
541: d.category_id , old_organization_id ,
542: old_inventory_item_id, b.LANGUAGE,
543: b.DESCRIPTION, b.LONG_DESCRIPTION,
544: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,a.concatenated_segments),

Line 718: 0, FND_GLOBAL.user_id,

714: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
715: , CATEGORY_SET_ID, WEB_STATUS)
716: SELECT
717: ibe_ct_imedia_search_s1.nextval,
718: 0, FND_GLOBAL.user_id,
719: SYSDATE, FND_GLOBAL.user_id,
720: SYSDATE, FND_GLOBAL.conc_login_id,
721: c.category_id , new_organization_id ,
722: new_inventory_item_id, new_LANGUAGE,

Line 719: SYSDATE, FND_GLOBAL.user_id,

715: , CATEGORY_SET_ID, WEB_STATUS)
716: SELECT
717: ibe_ct_imedia_search_s1.nextval,
718: 0, FND_GLOBAL.user_id,
719: SYSDATE, FND_GLOBAL.user_id,
720: SYSDATE, FND_GLOBAL.conc_login_id,
721: c.category_id , new_organization_id ,
722: new_inventory_item_id, new_LANGUAGE,
723: new_DESCRIPTION, new_LONG_DESCRIPTION,

Line 720: SYSDATE, FND_GLOBAL.conc_login_id,

716: SELECT
717: ibe_ct_imedia_search_s1.nextval,
718: 0, FND_GLOBAL.user_id,
719: SYSDATE, FND_GLOBAL.user_id,
720: SYSDATE, FND_GLOBAL.conc_login_id,
721: c.category_id , new_organization_id ,
722: new_inventory_item_id, new_LANGUAGE,
723: new_DESCRIPTION, new_LONG_DESCRIPTION,
724: ibe_search_setup_pvt.WriteToLob(new_description , new_long_description ,a.concatenated_segments),

Line 745: 0, FND_GLOBAL.user_id,

741: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
742: , CATEGORY_SET_ID, WEB_STATUS)
743: SELECT
744: ibe_ct_imedia_search_s1.nextval,
745: 0, FND_GLOBAL.user_id,
746: SYSDATE, FND_GLOBAL.user_id,
747: SYSDATE, FND_GLOBAL.conc_login_id,
748: c.category_id , new_organization_id ,
749: new_inventory_item_id, new_LANGUAGE,

Line 746: SYSDATE, FND_GLOBAL.user_id,

742: , CATEGORY_SET_ID, WEB_STATUS)
743: SELECT
744: ibe_ct_imedia_search_s1.nextval,
745: 0, FND_GLOBAL.user_id,
746: SYSDATE, FND_GLOBAL.user_id,
747: SYSDATE, FND_GLOBAL.conc_login_id,
748: c.category_id , new_organization_id ,
749: new_inventory_item_id, new_LANGUAGE,
750: new_DESCRIPTION, new_LONG_DESCRIPTION,

Line 747: SYSDATE, FND_GLOBAL.conc_login_id,

743: SELECT
744: ibe_ct_imedia_search_s1.nextval,
745: 0, FND_GLOBAL.user_id,
746: SYSDATE, FND_GLOBAL.user_id,
747: SYSDATE, FND_GLOBAL.conc_login_id,
748: c.category_id , new_organization_id ,
749: new_inventory_item_id, new_LANGUAGE,
750: new_DESCRIPTION, new_LONG_DESCRIPTION,
751: ibe_search_setup_pvt.WriteToLob(new_description , new_long_description ,a.concatenated_segments),

Line 771: 0, FND_GLOBAL.user_id,

767: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
768: , CATEGORY_SET_ID, WEB_STATUS)
769: SELECT
770: ibe_ct_imedia_search_s1.nextval,
771: 0, FND_GLOBAL.user_id,
772: SYSDATE, FND_GLOBAL.user_id,
773: SYSDATE, FND_GLOBAL.conc_login_id,
774: c.category_id , new_organization_id ,
775: new_inventory_item_id, new_LANGUAGE,

Line 772: SYSDATE, FND_GLOBAL.user_id,

768: , CATEGORY_SET_ID, WEB_STATUS)
769: SELECT
770: ibe_ct_imedia_search_s1.nextval,
771: 0, FND_GLOBAL.user_id,
772: SYSDATE, FND_GLOBAL.user_id,
773: SYSDATE, FND_GLOBAL.conc_login_id,
774: c.category_id , new_organization_id ,
775: new_inventory_item_id, new_LANGUAGE,
776: new_DESCRIPTION, new_LONG_DESCRIPTION,

Line 773: SYSDATE, FND_GLOBAL.conc_login_id,

769: SELECT
770: ibe_ct_imedia_search_s1.nextval,
771: 0, FND_GLOBAL.user_id,
772: SYSDATE, FND_GLOBAL.user_id,
773: SYSDATE, FND_GLOBAL.conc_login_id,
774: c.category_id , new_organization_id ,
775: new_inventory_item_id, new_LANGUAGE,
776: new_DESCRIPTION, new_LONG_DESCRIPTION,
777: ibe_search_setup_pvt.WriteToLob(new_description , new_long_description ,a.concatenated_segments),