eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_DSP_HIERARCHY_SETUP_PVT dependencies on FND_GLOBAL

Line 669: CREATED_BY = FND_GLOBAL.user_id,

665: FOR mapping IN c_get_component_mapping(p_source_section_id) LOOP
666: UPDATE ibe_dsp_obj_lgl_ctnt
667: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
668: ITEM_ID = mapping.item_id,
669: CREATED_BY = FND_GLOBAL.user_id,
670: CREATION_DATE = SYSDATE,
671: LAST_UPDATED_BY = FND_GLOBAL.user_id,
672: LAST_UPDATE_DATE = SYSDATE,
673: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 671: LAST_UPDATED_BY = FND_GLOBAL.user_id,

667: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
668: ITEM_ID = mapping.item_id,
669: CREATED_BY = FND_GLOBAL.user_id,
670: CREATION_DATE = SYSDATE,
671: LAST_UPDATED_BY = FND_GLOBAL.user_id,
672: LAST_UPDATE_DATE = SYSDATE,
673: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
674: WHERE object_id = p_target_section_id
675: AND object_type = 'S'

Line 673: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

669: CREATED_BY = FND_GLOBAL.user_id,
670: CREATION_DATE = SYSDATE,
671: LAST_UPDATED_BY = FND_GLOBAL.user_id,
672: LAST_UPDATE_DATE = SYSDATE,
673: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
674: WHERE object_id = p_target_section_id
675: AND object_type = 'S'
676: AND context_id = mapping.context_id;
677: IF sql%NOTFOUND THEN

Line 683: VALUES(ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL,1,FND_GLOBAL.user_id,SYSDATE,

679: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
680: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
681: SECURITY_GROUP_ID, CONTEXT_ID, OBJECT_TYPE, OBJECT_ID,
682: ITEM_ID)
683: VALUES(ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL,1,FND_GLOBAL.user_id,SYSDATE,
684: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.login_id, NULL,
685: mapping.context_id, 'S', p_target_section_id, mapping.item_id);
686: END IF;
687: END LOOP;

Line 684: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.login_id, NULL,

680: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
681: SECURITY_GROUP_ID, CONTEXT_ID, OBJECT_TYPE, OBJECT_ID,
682: ITEM_ID)
683: VALUES(ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL,1,FND_GLOBAL.user_id,SYSDATE,
684: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.login_id, NULL,
685: mapping.context_id, 'S', p_target_section_id, mapping.item_id);
686: END IF;
687: END LOOP;
688: ELSE

Line 711: CREATED_BY = FND_GLOBAL.user_id,

707: FOR mapping IN c_get_component_mapping_all(p_source_section_id) LOOP
708: UPDATE ibe_dsp_obj_lgl_ctnt
709: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
710: ITEM_ID = mapping.item_id,
711: CREATED_BY = FND_GLOBAL.user_id,
712: CREATION_DATE = SYSDATE,
713: LAST_UPDATED_BY = FND_GLOBAL.user_id,
714: LAST_UPDATE_DATE = SYSDATE,
715: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 713: LAST_UPDATED_BY = FND_GLOBAL.user_id,

709: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
710: ITEM_ID = mapping.item_id,
711: CREATED_BY = FND_GLOBAL.user_id,
712: CREATION_DATE = SYSDATE,
713: LAST_UPDATED_BY = FND_GLOBAL.user_id,
714: LAST_UPDATE_DATE = SYSDATE,
715: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
716: WHERE object_id = p_target_section_id
717: AND object_type = 'S'

Line 715: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

711: CREATED_BY = FND_GLOBAL.user_id,
712: CREATION_DATE = SYSDATE,
713: LAST_UPDATED_BY = FND_GLOBAL.user_id,
714: LAST_UPDATE_DATE = SYSDATE,
715: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
716: WHERE object_id = p_target_section_id
717: AND object_type = 'S'
718: AND context_id = mapping.context_id;
719: IF sql%NOTFOUND THEN

Line 725: VALUES(ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL,1,FND_GLOBAL.user_id,SYSDATE,

721: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
722: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
723: SECURITY_GROUP_ID, CONTEXT_ID, OBJECT_TYPE, OBJECT_ID,
724: ITEM_ID)
725: VALUES(ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL,1,FND_GLOBAL.user_id,SYSDATE,
726: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.login_id, NULL,
727: mapping.context_id, 'S', p_target_section_id, mapping.item_id);
728: END IF;
729: END LOOP;

Line 726: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.login_id, NULL,

722: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
723: SECURITY_GROUP_ID, CONTEXT_ID, OBJECT_TYPE, OBJECT_ID,
724: ITEM_ID)
725: VALUES(ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL,1,FND_GLOBAL.user_id,SYSDATE,
726: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.login_id, NULL,
727: mapping.context_id, 'S', p_target_section_id, mapping.item_id);
728: END IF;
729: END LOOP;
730: END IF;

Line 3179: last_updated_by = FND_GLOBAL.user_id

3175: start_date_active = l_start_date_active,
3176: end_date_active = l_end_date_active,
3177: sort_order = l_sort_order,
3178: last_update_date = SYSDATE,
3179: last_updated_by = FND_GLOBAL.user_id
3180: WHERE mini_site_id = l_old_mini_site_ids(j)
3181: AND child_section_id = p_section_id
3182: AND parent_section_id <> l_parent_section_id;
3183: END IF;

Line 5711: FND_GLOBAL.user_id,

5707: ) VALUES (
5708: l_lgl_phys_map_id,
5709: 1,
5710: SYSDATE,
5711: FND_GLOBAL.user_id,
5712: SYSDATE,
5713: FND_GLOBAL.user_id,
5714: FND_GLOBAL.login_id,
5715: p_msite_id,

Line 5713: FND_GLOBAL.user_id,

5709: 1,
5710: SYSDATE,
5711: FND_GLOBAL.user_id,
5712: SYSDATE,
5713: FND_GLOBAL.user_id,
5714: FND_GLOBAL.login_id,
5715: p_msite_id,
5716: p_language_code,
5717: p_attachment_id,

Line 5714: FND_GLOBAL.login_id,

5710: SYSDATE,
5711: FND_GLOBAL.user_id,
5712: SYSDATE,
5713: FND_GLOBAL.user_id,
5714: FND_GLOBAL.login_id,
5715: p_msite_id,
5716: p_language_code,
5717: p_attachment_id,
5718: p_item_id,

Line 5994: CREATED_BY = FND_GLOBAL.user_id,

5990: END IF;
5991: UPDATE ibe_dsp_obj_lgl_ctnt
5992: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
5993: ITEM_ID = mapping.item_id,
5994: CREATED_BY = FND_GLOBAL.user_id,
5995: CREATION_DATE = SYSDATE,
5996: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5997: LAST_UPDATE_DATE = SYSDATE,
5998: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 5996: LAST_UPDATED_BY = FND_GLOBAL.user_id,

5992: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
5993: ITEM_ID = mapping.item_id,
5994: CREATED_BY = FND_GLOBAL.user_id,
5995: CREATION_DATE = SYSDATE,
5996: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5997: LAST_UPDATE_DATE = SYSDATE,
5998: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
5999: WHERE object_id = p_target_section_id
6000: AND object_type = 'S'

Line 5998: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

5994: CREATED_BY = FND_GLOBAL.user_id,
5995: CREATION_DATE = SYSDATE,
5996: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5997: LAST_UPDATE_DATE = SYSDATE,
5998: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
5999: WHERE object_id = p_target_section_id
6000: AND object_type = 'S'
6001: AND context_id = mapping.context_id;
6002: IF sql%NOTFOUND THEN

Line 6008: VALUES(ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL,1,FND_GLOBAL.user_id,SYSDATE,

6004: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
6005: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
6006: SECURITY_GROUP_ID, CONTEXT_ID, OBJECT_TYPE, OBJECT_ID,
6007: ITEM_ID)
6008: VALUES(ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL,1,FND_GLOBAL.user_id,SYSDATE,
6009: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.login_id, NULL,
6010: mapping.context_id, 'S', p_target_section_id, mapping.item_id);
6011: END IF;
6012: x_section_ids.extend(1);

Line 6009: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.login_id, NULL,

6005: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
6006: SECURITY_GROUP_ID, CONTEXT_ID, OBJECT_TYPE, OBJECT_ID,
6007: ITEM_ID)
6008: VALUES(ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL,1,FND_GLOBAL.user_id,SYSDATE,
6009: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.login_id, NULL,
6010: mapping.context_id, 'S', p_target_section_id, mapping.item_id);
6011: END IF;
6012: x_section_ids.extend(1);
6013: x_layout_comp_ids.extend(1);

Line 6183: last_updated_by = FND_GLOBAL.user_id,

6179: -- dbms_output.put_line('Before updating ibe_dsp_sections_b');
6180: UPDATE ibe_dsp_sections_b
6181: SET deliverable_id = l_new_deliverable_id,
6182: last_update_date = SYSDATE,
6183: last_updated_by = FND_GLOBAL.user_id,
6184: object_version_number = object_version_number + 1
6185: WHERE section_id = p_section_id;
6186: -- dbms_output.put_line('After updating ibe_dsp_sections_b');
6187: -------------------------------------

Line 6217: VALUES(ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL, 1, FND_GLOBAL.user_id,

6213: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
6214: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
6215: SECURITY_GROUP_ID, CONTEXT_ID, OBJECT_TYPE, OBJECT_ID,
6216: ITEM_ID)
6217: VALUES(ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL, 1, FND_GLOBAL.user_id,
6218: SYSDATE, FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.login_id,
6219: NULL, p_layout_comp_id(l_i), 'S', p_section_id,
6220: p_layout_temp_id(l_i));
6221: ELSIF (p_actionflags(l_i) = 'U') AND

Line 6218: SYSDATE, FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.login_id,

6214: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
6215: SECURITY_GROUP_ID, CONTEXT_ID, OBJECT_TYPE, OBJECT_ID,
6216: ITEM_ID)
6217: VALUES(ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL, 1, FND_GLOBAL.user_id,
6218: SYSDATE, FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.login_id,
6219: NULL, p_layout_comp_id(l_i), 'S', p_section_id,
6220: p_layout_temp_id(l_i));
6221: ELSIF (p_actionflags(l_i) = 'U') AND
6222: (p_layout_temp_id(l_i) IS NOT NULL) THEN

Line 6231: CREATED_BY = FND_GLOBAL.user_id,

6227: x_layout_comp_ids(l_idx) := p_layout_comp_id(l_i);
6228: UPDATE ibe_dsp_obj_lgl_ctnt
6229: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
6230: ITEM_ID = p_layout_temp_id(l_i),
6231: CREATED_BY = FND_GLOBAL.user_id,
6232: CREATION_DATE = SYSDATE,
6233: LAST_UPDATED_BY = FND_GLOBAL.user_id,
6234: LAST_UPDATE_DATE = SYSDATE,
6235: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 6233: LAST_UPDATED_BY = FND_GLOBAL.user_id,

6229: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
6230: ITEM_ID = p_layout_temp_id(l_i),
6231: CREATED_BY = FND_GLOBAL.user_id,
6232: CREATION_DATE = SYSDATE,
6233: LAST_UPDATED_BY = FND_GLOBAL.user_id,
6234: LAST_UPDATE_DATE = SYSDATE,
6235: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
6236: WHERE object_id = p_section_id
6237: AND object_type = 'S'

Line 6235: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

6231: CREATED_BY = FND_GLOBAL.user_id,
6232: CREATION_DATE = SYSDATE,
6233: LAST_UPDATED_BY = FND_GLOBAL.user_id,
6234: LAST_UPDATE_DATE = SYSDATE,
6235: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
6236: WHERE object_id = p_section_id
6237: AND object_type = 'S'
6238: AND context_id = p_layout_comp_id(l_i)
6239: AND object_version_number = p_object_versions(l_i);

Line 6258: last_updated_by = FND_GLOBAL.user_id,

6254: l_master_minisite_id) LOOP
6255: UPDATE ibe_dsp_sections_b
6256: SET deliverable_id = l_new_deliverable_id,
6257: last_update_date = SYSDATE,
6258: last_updated_by = FND_GLOBAL.user_id,
6259: object_version_number = object_version_number + 1
6260: WHERE section_id = child_section.child_section_id;
6261: -- Get the original layout of the section
6262: Cascade_Layout_Comp_Mapping