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.PO_ATTRIBUTE_VALUES_PVT dependencies on FND_GLOBAL

Line 3371: FND_GLOBAL.login_id, -- last_update_login

3367: TLP1.tl_text_cat_attribute47,
3368: TLP1.tl_text_cat_attribute48,
3369: TLP1.tl_text_cat_attribute49,
3370: TLP1.tl_text_cat_attribute50,
3371: FND_GLOBAL.login_id, -- last_update_login
3372: FND_GLOBAL.user_id, -- last_updated_by
3373: sysdate, -- last_update_date
3374: FND_GLOBAL.user_id, -- created_by
3375: sysdate, -- creation_date

Line 3372: FND_GLOBAL.user_id, -- last_updated_by

3368: TLP1.tl_text_cat_attribute48,
3369: TLP1.tl_text_cat_attribute49,
3370: TLP1.tl_text_cat_attribute50,
3371: FND_GLOBAL.login_id, -- last_update_login
3372: FND_GLOBAL.user_id, -- last_updated_by
3373: sysdate, -- last_update_date
3374: FND_GLOBAL.user_id, -- created_by
3375: sysdate, -- creation_date
3376: FND_GLOBAL.conc_request_id, -- request_id

Line 3374: FND_GLOBAL.user_id, -- created_by

3370: TLP1.tl_text_cat_attribute50,
3371: FND_GLOBAL.login_id, -- last_update_login
3372: FND_GLOBAL.user_id, -- last_updated_by
3373: sysdate, -- last_update_date
3374: FND_GLOBAL.user_id, -- created_by
3375: sysdate, -- creation_date
3376: FND_GLOBAL.conc_request_id, -- request_id
3377: TLP1.program_application_id,
3378: TLP1.program_id,

Line 3376: FND_GLOBAL.conc_request_id, -- request_id

3372: FND_GLOBAL.user_id, -- last_updated_by
3373: sysdate, -- last_update_date
3374: FND_GLOBAL.user_id, -- created_by
3375: sysdate, -- creation_date
3376: FND_GLOBAL.conc_request_id, -- request_id
3377: TLP1.program_application_id,
3378: TLP1.program_id,
3379: TLP1.program_update_date,
3380: d_mod -- last_updated_program

Line 3531: FND_GLOBAL.login_id, -- last_update_login

3527: l_description,
3528: p_manufacturer,
3529: l_long_description,
3530: -- WHO columns
3531: FND_GLOBAL.login_id, -- last_update_login
3532: FND_GLOBAL.user_id, -- last_updated_by
3533: sysdate, -- last_update_date
3534: FND_GLOBAL.user_id, -- created_by
3535: sysdate, -- creation_date

Line 3532: FND_GLOBAL.user_id, -- last_updated_by

3528: p_manufacturer,
3529: l_long_description,
3530: -- WHO columns
3531: FND_GLOBAL.login_id, -- last_update_login
3532: FND_GLOBAL.user_id, -- last_updated_by
3533: sysdate, -- last_update_date
3534: FND_GLOBAL.user_id, -- created_by
3535: sysdate, -- creation_date
3536: FND_GLOBAL.conc_request_id, -- request_id

Line 3534: FND_GLOBAL.user_id, -- created_by

3530: -- WHO columns
3531: FND_GLOBAL.login_id, -- last_update_login
3532: FND_GLOBAL.user_id, -- last_updated_by
3533: sysdate, -- last_update_date
3534: FND_GLOBAL.user_id, -- created_by
3535: sysdate, -- creation_date
3536: FND_GLOBAL.conc_request_id, -- request_id
3537: FND_GLOBAL.prog_appl_id, -- program_application_id
3538: FND_GLOBAL.conc_program_id, -- program_id

Line 3536: FND_GLOBAL.conc_request_id, -- request_id

3532: FND_GLOBAL.user_id, -- last_updated_by
3533: sysdate, -- last_update_date
3534: FND_GLOBAL.user_id, -- created_by
3535: sysdate, -- creation_date
3536: FND_GLOBAL.conc_request_id, -- request_id
3537: FND_GLOBAL.prog_appl_id, -- program_application_id
3538: FND_GLOBAL.conc_program_id, -- program_id
3539: sysdate, -- program_update_date
3540: d_mod -- last_updated_program

Line 3537: FND_GLOBAL.prog_appl_id, -- program_application_id

3533: sysdate, -- last_update_date
3534: FND_GLOBAL.user_id, -- created_by
3535: sysdate, -- creation_date
3536: FND_GLOBAL.conc_request_id, -- request_id
3537: FND_GLOBAL.prog_appl_id, -- program_application_id
3538: FND_GLOBAL.conc_program_id, -- program_id
3539: sysdate, -- program_update_date
3540: d_mod -- last_updated_program
3541: FROM DUAL

Line 3538: FND_GLOBAL.conc_program_id, -- program_id

3534: FND_GLOBAL.user_id, -- created_by
3535: sysdate, -- creation_date
3536: FND_GLOBAL.conc_request_id, -- request_id
3537: FND_GLOBAL.prog_appl_id, -- program_application_id
3538: FND_GLOBAL.conc_program_id, -- program_id
3539: sysdate, -- program_update_date
3540: d_mod -- last_updated_program
3541: FROM DUAL
3542: WHERE NOT EXISTS

Line 3698: FND_GLOBAL.login_id, -- last_update_login

3694: NVL(p_org_id,-2),
3695: l_manufacturer_part_num,
3696: l_lead_time,
3697: -- WHO columns
3698: FND_GLOBAL.login_id, -- last_update_login
3699: FND_GLOBAL.user_id, -- last_updated_by
3700: sysdate, -- last_update_date
3701: FND_GLOBAL.user_id, -- created_by
3702: sysdate, -- creation_date

Line 3699: FND_GLOBAL.user_id, -- last_updated_by

3695: l_manufacturer_part_num,
3696: l_lead_time,
3697: -- WHO columns
3698: FND_GLOBAL.login_id, -- last_update_login
3699: FND_GLOBAL.user_id, -- last_updated_by
3700: sysdate, -- last_update_date
3701: FND_GLOBAL.user_id, -- created_by
3702: sysdate, -- creation_date
3703: FND_GLOBAL.conc_request_id, -- request_id

Line 3701: FND_GLOBAL.user_id, -- created_by

3697: -- WHO columns
3698: FND_GLOBAL.login_id, -- last_update_login
3699: FND_GLOBAL.user_id, -- last_updated_by
3700: sysdate, -- last_update_date
3701: FND_GLOBAL.user_id, -- created_by
3702: sysdate, -- creation_date
3703: FND_GLOBAL.conc_request_id, -- request_id
3704: FND_GLOBAL.prog_appl_id, -- program_application_id
3705: FND_GLOBAL.conc_program_id, -- program_id

Line 3703: FND_GLOBAL.conc_request_id, -- request_id

3699: FND_GLOBAL.user_id, -- last_updated_by
3700: sysdate, -- last_update_date
3701: FND_GLOBAL.user_id, -- created_by
3702: sysdate, -- creation_date
3703: FND_GLOBAL.conc_request_id, -- request_id
3704: FND_GLOBAL.prog_appl_id, -- program_application_id
3705: FND_GLOBAL.conc_program_id, -- program_id
3706: sysdate, -- program_update_date
3707: d_mod -- last_updated_program

Line 3704: FND_GLOBAL.prog_appl_id, -- program_application_id

3700: sysdate, -- last_update_date
3701: FND_GLOBAL.user_id, -- created_by
3702: sysdate, -- creation_date
3703: FND_GLOBAL.conc_request_id, -- request_id
3704: FND_GLOBAL.prog_appl_id, -- program_application_id
3705: FND_GLOBAL.conc_program_id, -- program_id
3706: sysdate, -- program_update_date
3707: d_mod -- last_updated_program
3708: FROM DUAL

Line 3705: FND_GLOBAL.conc_program_id, -- program_id

3701: FND_GLOBAL.user_id, -- created_by
3702: sysdate, -- creation_date
3703: FND_GLOBAL.conc_request_id, -- request_id
3704: FND_GLOBAL.prog_appl_id, -- program_application_id
3705: FND_GLOBAL.conc_program_id, -- program_id
3706: sysdate, -- program_update_date
3707: d_mod -- last_updated_program
3708: FROM DUAL
3709: WHERE NOT EXISTS

Line 3839: FND_GLOBAL.login_id, -- last_update_login

3835: NVL(p_org_id,-2),
3836: l_manufacturer_part_num,
3837: l_proc_lead_time,
3838: -- WHO columns
3839: FND_GLOBAL.login_id, -- last_update_login
3840: FND_GLOBAL.user_id, -- last_updated_by
3841: sysdate, -- last_update_date
3842: FND_GLOBAL.user_id, -- created_by
3843: sysdate, -- creation_date

Line 3840: FND_GLOBAL.user_id, -- last_updated_by

3836: l_manufacturer_part_num,
3837: l_proc_lead_time,
3838: -- WHO columns
3839: FND_GLOBAL.login_id, -- last_update_login
3840: FND_GLOBAL.user_id, -- last_updated_by
3841: sysdate, -- last_update_date
3842: FND_GLOBAL.user_id, -- created_by
3843: sysdate, -- creation_date
3844: FND_GLOBAL.conc_request_id, -- request_id

Line 3842: FND_GLOBAL.user_id, -- created_by

3838: -- WHO columns
3839: FND_GLOBAL.login_id, -- last_update_login
3840: FND_GLOBAL.user_id, -- last_updated_by
3841: sysdate, -- last_update_date
3842: FND_GLOBAL.user_id, -- created_by
3843: sysdate, -- creation_date
3844: FND_GLOBAL.conc_request_id, -- request_id
3845: FND_GLOBAL.prog_appl_id, -- program_application_id
3846: FND_GLOBAL.conc_program_id, -- program_id

Line 3844: FND_GLOBAL.conc_request_id, -- request_id

3840: FND_GLOBAL.user_id, -- last_updated_by
3841: sysdate, -- last_update_date
3842: FND_GLOBAL.user_id, -- created_by
3843: sysdate, -- creation_date
3844: FND_GLOBAL.conc_request_id, -- request_id
3845: FND_GLOBAL.prog_appl_id, -- program_application_id
3846: FND_GLOBAL.conc_program_id, -- program_id
3847: sysdate, -- program_update_date
3848: d_mod -- last_updated_program

Line 3845: FND_GLOBAL.prog_appl_id, -- program_application_id

3841: sysdate, -- last_update_date
3842: FND_GLOBAL.user_id, -- created_by
3843: sysdate, -- creation_date
3844: FND_GLOBAL.conc_request_id, -- request_id
3845: FND_GLOBAL.prog_appl_id, -- program_application_id
3846: FND_GLOBAL.conc_program_id, -- program_id
3847: sysdate, -- program_update_date
3848: d_mod -- last_updated_program
3849: FROM DUAL

Line 3846: FND_GLOBAL.conc_program_id, -- program_id

3842: FND_GLOBAL.user_id, -- created_by
3843: sysdate, -- creation_date
3844: FND_GLOBAL.conc_request_id, -- request_id
3845: FND_GLOBAL.prog_appl_id, -- program_application_id
3846: FND_GLOBAL.conc_program_id, -- program_id
3847: sysdate, -- program_update_date
3848: d_mod -- last_updated_program
3849: FROM DUAL
3850: WHERE NOT EXISTS

Line 4000: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

3996: TEXT_CAT_ATTRIBUTE48 = NULL,
3997: TEXT_CAT_ATTRIBUTE49 = NULL,
3998: TEXT_CAT_ATTRIBUTE50 = NULL,
3999: -- WHO columns
4000: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4001: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4002: LAST_UPDATE_DATE = sysdate,
4003: CREATED_BY = FND_GLOBAL.user_id,
4004: CREATION_DATE = sysdate,

Line 4001: LAST_UPDATED_BY = FND_GLOBAL.user_id,

3997: TEXT_CAT_ATTRIBUTE49 = NULL,
3998: TEXT_CAT_ATTRIBUTE50 = NULL,
3999: -- WHO columns
4000: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4001: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4002: LAST_UPDATE_DATE = sysdate,
4003: CREATED_BY = FND_GLOBAL.user_id,
4004: CREATION_DATE = sysdate,
4005: REQUEST_ID = FND_GLOBAL.conc_request_id,

Line 4003: CREATED_BY = FND_GLOBAL.user_id,

3999: -- WHO columns
4000: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4001: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4002: LAST_UPDATE_DATE = sysdate,
4003: CREATED_BY = FND_GLOBAL.user_id,
4004: CREATION_DATE = sysdate,
4005: REQUEST_ID = FND_GLOBAL.conc_request_id,
4006: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4007: PROGRAM_ID = FND_GLOBAL.conc_program_id,

Line 4005: REQUEST_ID = FND_GLOBAL.conc_request_id,

4001: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4002: LAST_UPDATE_DATE = sysdate,
4003: CREATED_BY = FND_GLOBAL.user_id,
4004: CREATION_DATE = sysdate,
4005: REQUEST_ID = FND_GLOBAL.conc_request_id,
4006: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4007: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4008: PROGRAM_UPDATE_DATE = sysdate,
4009: LAST_UPDATED_PROGRAM = d_mod

Line 4006: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

4002: LAST_UPDATE_DATE = sysdate,
4003: CREATED_BY = FND_GLOBAL.user_id,
4004: CREATION_DATE = sysdate,
4005: REQUEST_ID = FND_GLOBAL.conc_request_id,
4006: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4007: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4008: PROGRAM_UPDATE_DATE = sysdate,
4009: LAST_UPDATED_PROGRAM = d_mod
4010: WHERE po_line_id = -2

Line 4007: PROGRAM_ID = FND_GLOBAL.conc_program_id,

4003: CREATED_BY = FND_GLOBAL.user_id,
4004: CREATION_DATE = sysdate,
4005: REQUEST_ID = FND_GLOBAL.conc_request_id,
4006: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4007: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4008: PROGRAM_UPDATE_DATE = sysdate,
4009: LAST_UPDATED_PROGRAM = d_mod
4010: WHERE po_line_id = -2
4011: AND req_template_name = '-2'

Line 4075: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

4071: TL_TEXT_CAT_ATTRIBUTE48 = NULL,
4072: TL_TEXT_CAT_ATTRIBUTE49 = NULL,
4073: TL_TEXT_CAT_ATTRIBUTE50 = NULL,
4074: -- WHO columns
4075: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4076: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4077: LAST_UPDATE_DATE = sysdate,
4078: CREATED_BY = FND_GLOBAL.user_id,
4079: CREATION_DATE = sysdate,

Line 4076: LAST_UPDATED_BY = FND_GLOBAL.user_id,

4072: TL_TEXT_CAT_ATTRIBUTE49 = NULL,
4073: TL_TEXT_CAT_ATTRIBUTE50 = NULL,
4074: -- WHO columns
4075: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4076: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4077: LAST_UPDATE_DATE = sysdate,
4078: CREATED_BY = FND_GLOBAL.user_id,
4079: CREATION_DATE = sysdate,
4080: REQUEST_ID = FND_GLOBAL.conc_request_id,

Line 4078: CREATED_BY = FND_GLOBAL.user_id,

4074: -- WHO columns
4075: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4076: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4077: LAST_UPDATE_DATE = sysdate,
4078: CREATED_BY = FND_GLOBAL.user_id,
4079: CREATION_DATE = sysdate,
4080: REQUEST_ID = FND_GLOBAL.conc_request_id,
4081: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4082: PROGRAM_ID = FND_GLOBAL.conc_program_id,

Line 4080: REQUEST_ID = FND_GLOBAL.conc_request_id,

4076: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4077: LAST_UPDATE_DATE = sysdate,
4078: CREATED_BY = FND_GLOBAL.user_id,
4079: CREATION_DATE = sysdate,
4080: REQUEST_ID = FND_GLOBAL.conc_request_id,
4081: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4082: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4083: PROGRAM_UPDATE_DATE = sysdate,
4084: LAST_UPDATED_PROGRAM = d_mod

Line 4081: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

4077: LAST_UPDATE_DATE = sysdate,
4078: CREATED_BY = FND_GLOBAL.user_id,
4079: CREATION_DATE = sysdate,
4080: REQUEST_ID = FND_GLOBAL.conc_request_id,
4081: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4082: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4083: PROGRAM_UPDATE_DATE = sysdate,
4084: LAST_UPDATED_PROGRAM = d_mod
4085: WHERE po_line_id = -2

Line 4082: PROGRAM_ID = FND_GLOBAL.conc_program_id,

4078: CREATED_BY = FND_GLOBAL.user_id,
4079: CREATION_DATE = sysdate,
4080: REQUEST_ID = FND_GLOBAL.conc_request_id,
4081: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4082: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4083: PROGRAM_UPDATE_DATE = sysdate,
4084: LAST_UPDATED_PROGRAM = d_mod
4085: WHERE po_line_id = -2
4086: AND req_template_name = '-2'

Line 4227: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

4223: SET ip_category_id = p_ip_category_id,
4224: MANUFACTURER_PART_NUM = l_manufacturer_part_num,
4225: LEAD_TIME = l_proc_lead_time,
4226: -- WHO columns
4227: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4228: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4229: LAST_UPDATE_DATE = sysdate,
4230: CREATED_BY = FND_GLOBAL.user_id,
4231: CREATION_DATE = sysdate,

Line 4228: LAST_UPDATED_BY = FND_GLOBAL.user_id,

4224: MANUFACTURER_PART_NUM = l_manufacturer_part_num,
4225: LEAD_TIME = l_proc_lead_time,
4226: -- WHO columns
4227: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4228: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4229: LAST_UPDATE_DATE = sysdate,
4230: CREATED_BY = FND_GLOBAL.user_id,
4231: CREATION_DATE = sysdate,
4232: REQUEST_ID = FND_GLOBAL.conc_request_id,

Line 4230: CREATED_BY = FND_GLOBAL.user_id,

4226: -- WHO columns
4227: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4228: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4229: LAST_UPDATE_DATE = sysdate,
4230: CREATED_BY = FND_GLOBAL.user_id,
4231: CREATION_DATE = sysdate,
4232: REQUEST_ID = FND_GLOBAL.conc_request_id,
4233: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4234: PROGRAM_ID = FND_GLOBAL.conc_program_id,

Line 4232: REQUEST_ID = FND_GLOBAL.conc_request_id,

4228: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4229: LAST_UPDATE_DATE = sysdate,
4230: CREATED_BY = FND_GLOBAL.user_id,
4231: CREATION_DATE = sysdate,
4232: REQUEST_ID = FND_GLOBAL.conc_request_id,
4233: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4234: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4235: PROGRAM_UPDATE_DATE = sysdate,
4236: LAST_UPDATED_PROGRAM = d_mod

Line 4233: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

4229: LAST_UPDATE_DATE = sysdate,
4230: CREATED_BY = FND_GLOBAL.user_id,
4231: CREATION_DATE = sysdate,
4232: REQUEST_ID = FND_GLOBAL.conc_request_id,
4233: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4234: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4235: PROGRAM_UPDATE_DATE = sysdate,
4236: LAST_UPDATED_PROGRAM = d_mod
4237: WHERE po_line_id = -2

Line 4234: PROGRAM_ID = FND_GLOBAL.conc_program_id,

4230: CREATED_BY = FND_GLOBAL.user_id,
4231: CREATION_DATE = sysdate,
4232: REQUEST_ID = FND_GLOBAL.conc_request_id,
4233: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4234: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4235: PROGRAM_UPDATE_DATE = sysdate,
4236: LAST_UPDATED_PROGRAM = d_mod
4237: WHERE po_line_id = -2
4238: AND req_template_name = '-2'

Line 4317: FND_GLOBAL.login_id, -- last_update_login

4313: p_inventory_item_id,
4314: p_org_id,
4315: l_manufacturer,
4316: l_new_long_description,
4317: FND_GLOBAL.login_id, -- last_update_login
4318: FND_GLOBAL.user_id, -- last_updated_by
4319: sysdate, -- last_update_date
4320: FND_GLOBAL.user_id, -- created_by
4321: sysdate, -- creation_date

Line 4318: FND_GLOBAL.user_id, -- last_updated_by

4314: p_org_id,
4315: l_manufacturer,
4316: l_new_long_description,
4317: FND_GLOBAL.login_id, -- last_update_login
4318: FND_GLOBAL.user_id, -- last_updated_by
4319: sysdate, -- last_update_date
4320: FND_GLOBAL.user_id, -- created_by
4321: sysdate, -- creation_date
4322: FND_GLOBAL.conc_request_id, -- request_id

Line 4320: FND_GLOBAL.user_id, -- created_by

4316: l_new_long_description,
4317: FND_GLOBAL.login_id, -- last_update_login
4318: FND_GLOBAL.user_id, -- last_updated_by
4319: sysdate, -- last_update_date
4320: FND_GLOBAL.user_id, -- created_by
4321: sysdate, -- creation_date
4322: FND_GLOBAL.conc_request_id, -- request_id
4323: FND_GLOBAL.prog_appl_id,
4324: FND_GLOBAL.conc_program_id, -- program_id

Line 4322: FND_GLOBAL.conc_request_id, -- request_id

4318: FND_GLOBAL.user_id, -- last_updated_by
4319: sysdate, -- last_update_date
4320: FND_GLOBAL.user_id, -- created_by
4321: sysdate, -- creation_date
4322: FND_GLOBAL.conc_request_id, -- request_id
4323: FND_GLOBAL.prog_appl_id,
4324: FND_GLOBAL.conc_program_id, -- program_id
4325: sysdate, -- program_update_date
4326: d_mod -- last_updated_program

Line 4323: FND_GLOBAL.prog_appl_id,

4319: sysdate, -- last_update_date
4320: FND_GLOBAL.user_id, -- created_by
4321: sysdate, -- creation_date
4322: FND_GLOBAL.conc_request_id, -- request_id
4323: FND_GLOBAL.prog_appl_id,
4324: FND_GLOBAL.conc_program_id, -- program_id
4325: sysdate, -- program_update_date
4326: d_mod -- last_updated_program
4327: FROM dual;

Line 4324: FND_GLOBAL.conc_program_id, -- program_id

4320: FND_GLOBAL.user_id, -- created_by
4321: sysdate, -- creation_date
4322: FND_GLOBAL.conc_request_id, -- request_id
4323: FND_GLOBAL.prog_appl_id,
4324: FND_GLOBAL.conc_program_id, -- program_id
4325: sysdate, -- program_update_date
4326: d_mod -- last_updated_program
4327: FROM dual;
4328:

Line 4363: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

4359: description = p_item_description,
4360: manufacturer = l_manufacturer,
4361: long_description = l_new_long_description,
4362: -- WHO columns
4363: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4364: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4365: LAST_UPDATE_DATE = sysdate,
4366: CREATED_BY = FND_GLOBAL.user_id,
4367: CREATION_DATE = sysdate,

Line 4364: LAST_UPDATED_BY = FND_GLOBAL.user_id,

4360: manufacturer = l_manufacturer,
4361: long_description = l_new_long_description,
4362: -- WHO columns
4363: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4364: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4365: LAST_UPDATE_DATE = sysdate,
4366: CREATED_BY = FND_GLOBAL.user_id,
4367: CREATION_DATE = sysdate,
4368: REQUEST_ID = FND_GLOBAL.conc_request_id,

Line 4366: CREATED_BY = FND_GLOBAL.user_id,

4362: -- WHO columns
4363: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4364: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4365: LAST_UPDATE_DATE = sysdate,
4366: CREATED_BY = FND_GLOBAL.user_id,
4367: CREATION_DATE = sysdate,
4368: REQUEST_ID = FND_GLOBAL.conc_request_id,
4369: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4370: PROGRAM_ID = FND_GLOBAL.conc_program_id,

Line 4368: REQUEST_ID = FND_GLOBAL.conc_request_id,

4364: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4365: LAST_UPDATE_DATE = sysdate,
4366: CREATED_BY = FND_GLOBAL.user_id,
4367: CREATION_DATE = sysdate,
4368: REQUEST_ID = FND_GLOBAL.conc_request_id,
4369: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4370: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4371: PROGRAM_UPDATE_DATE = sysdate,
4372: LAST_UPDATED_PROGRAM = d_mod

Line 4369: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

4365: LAST_UPDATE_DATE = sysdate,
4366: CREATED_BY = FND_GLOBAL.user_id,
4367: CREATION_DATE = sysdate,
4368: REQUEST_ID = FND_GLOBAL.conc_request_id,
4369: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4370: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4371: PROGRAM_UPDATE_DATE = sysdate,
4372: LAST_UPDATED_PROGRAM = d_mod
4373: WHERE po_line_id = -2

Line 4370: PROGRAM_ID = FND_GLOBAL.conc_program_id,

4366: CREATED_BY = FND_GLOBAL.user_id,
4367: CREATION_DATE = sysdate,
4368: REQUEST_ID = FND_GLOBAL.conc_request_id,
4369: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4370: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4371: PROGRAM_UPDATE_DATE = sysdate,
4372: LAST_UPDATED_PROGRAM = d_mod
4373: WHERE po_line_id = -2
4374: AND req_template_name = '-2'

Line 4639: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

4635: TEXT_CAT_ATTRIBUTE48 = NULL,
4636: TEXT_CAT_ATTRIBUTE49 = NULL,
4637: TEXT_CAT_ATTRIBUTE50 = NULL,
4638: -- WHO columns
4639: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4640: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4641: LAST_UPDATE_DATE = sysdate,
4642: CREATED_BY = FND_GLOBAL.user_id,
4643: CREATION_DATE = sysdate,

Line 4640: LAST_UPDATED_BY = FND_GLOBAL.user_id,

4636: TEXT_CAT_ATTRIBUTE49 = NULL,
4637: TEXT_CAT_ATTRIBUTE50 = NULL,
4638: -- WHO columns
4639: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4640: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4641: LAST_UPDATE_DATE = sysdate,
4642: CREATED_BY = FND_GLOBAL.user_id,
4643: CREATION_DATE = sysdate,
4644: REQUEST_ID = FND_GLOBAL.conc_request_id,

Line 4642: CREATED_BY = FND_GLOBAL.user_id,

4638: -- WHO columns
4639: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4640: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4641: LAST_UPDATE_DATE = sysdate,
4642: CREATED_BY = FND_GLOBAL.user_id,
4643: CREATION_DATE = sysdate,
4644: REQUEST_ID = FND_GLOBAL.conc_request_id,
4645: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4646: PROGRAM_ID = FND_GLOBAL.conc_program_id,

Line 4644: REQUEST_ID = FND_GLOBAL.conc_request_id,

4640: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4641: LAST_UPDATE_DATE = sysdate,
4642: CREATED_BY = FND_GLOBAL.user_id,
4643: CREATION_DATE = sysdate,
4644: REQUEST_ID = FND_GLOBAL.conc_request_id,
4645: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4646: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4647: PROGRAM_UPDATE_DATE = sysdate,
4648: LAST_UPDATED_PROGRAM = d_mod

Line 4645: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

4641: LAST_UPDATE_DATE = sysdate,
4642: CREATED_BY = FND_GLOBAL.user_id,
4643: CREATION_DATE = sysdate,
4644: REQUEST_ID = FND_GLOBAL.conc_request_id,
4645: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4646: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4647: PROGRAM_UPDATE_DATE = sysdate,
4648: LAST_UPDATED_PROGRAM = d_mod
4649: WHERE po_line_id = NVL(p_po_line_id, -2)

Line 4646: PROGRAM_ID = FND_GLOBAL.conc_program_id,

4642: CREATED_BY = FND_GLOBAL.user_id,
4643: CREATION_DATE = sysdate,
4644: REQUEST_ID = FND_GLOBAL.conc_request_id,
4645: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4646: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4647: PROGRAM_UPDATE_DATE = sysdate,
4648: LAST_UPDATED_PROGRAM = d_mod
4649: WHERE po_line_id = NVL(p_po_line_id, -2)
4650: AND req_template_name = NVL(p_req_template_name, '-2')

Line 4713: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

4709: TL_TEXT_CAT_ATTRIBUTE48 = NULL,
4710: TL_TEXT_CAT_ATTRIBUTE49 = NULL,
4711: TL_TEXT_CAT_ATTRIBUTE50 = NULL,
4712: -- WHO columns
4713: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4714: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4715: LAST_UPDATE_DATE = sysdate,
4716: CREATED_BY = FND_GLOBAL.user_id,
4717: CREATION_DATE = sysdate,

Line 4714: LAST_UPDATED_BY = FND_GLOBAL.user_id,

4710: TL_TEXT_CAT_ATTRIBUTE49 = NULL,
4711: TL_TEXT_CAT_ATTRIBUTE50 = NULL,
4712: -- WHO columns
4713: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4714: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4715: LAST_UPDATE_DATE = sysdate,
4716: CREATED_BY = FND_GLOBAL.user_id,
4717: CREATION_DATE = sysdate,
4718: REQUEST_ID = FND_GLOBAL.conc_request_id,

Line 4716: CREATED_BY = FND_GLOBAL.user_id,

4712: -- WHO columns
4713: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4714: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4715: LAST_UPDATE_DATE = sysdate,
4716: CREATED_BY = FND_GLOBAL.user_id,
4717: CREATION_DATE = sysdate,
4718: REQUEST_ID = FND_GLOBAL.conc_request_id,
4719: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4720: PROGRAM_ID = FND_GLOBAL.conc_program_id,

Line 4718: REQUEST_ID = FND_GLOBAL.conc_request_id,

4714: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4715: LAST_UPDATE_DATE = sysdate,
4716: CREATED_BY = FND_GLOBAL.user_id,
4717: CREATION_DATE = sysdate,
4718: REQUEST_ID = FND_GLOBAL.conc_request_id,
4719: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4720: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4721: PROGRAM_UPDATE_DATE = sysdate,
4722: LAST_UPDATED_PROGRAM = d_mod

Line 4719: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

4715: LAST_UPDATE_DATE = sysdate,
4716: CREATED_BY = FND_GLOBAL.user_id,
4717: CREATION_DATE = sysdate,
4718: REQUEST_ID = FND_GLOBAL.conc_request_id,
4719: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4720: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4721: PROGRAM_UPDATE_DATE = sysdate,
4722: LAST_UPDATED_PROGRAM = d_mod
4723: WHERE po_line_id = NVL(p_po_line_id, -2)

Line 4720: PROGRAM_ID = FND_GLOBAL.conc_program_id,

4716: CREATED_BY = FND_GLOBAL.user_id,
4717: CREATION_DATE = sysdate,
4718: REQUEST_ID = FND_GLOBAL.conc_request_id,
4719: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4720: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4721: PROGRAM_UPDATE_DATE = sysdate,
4722: LAST_UPDATED_PROGRAM = d_mod
4723: WHERE po_line_id = NVL(p_po_line_id, -2)
4724: AND req_template_name = NVL(p_req_template_name, '-2')

Line 4856: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

4852: -- SQL Join: po_line_id, req_template_name, req_template_line_num, org_id
4853: UPDATE PO_ATTRIBUTE_VALUES
4854: SET ip_category_id = p_ip_category_id,
4855: -- WHO columns
4856: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4857: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4858: LAST_UPDATE_DATE = sysdate,
4859: CREATED_BY = FND_GLOBAL.user_id,
4860: CREATION_DATE = sysdate,

Line 4857: LAST_UPDATED_BY = FND_GLOBAL.user_id,

4853: UPDATE PO_ATTRIBUTE_VALUES
4854: SET ip_category_id = p_ip_category_id,
4855: -- WHO columns
4856: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4857: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4858: LAST_UPDATE_DATE = sysdate,
4859: CREATED_BY = FND_GLOBAL.user_id,
4860: CREATION_DATE = sysdate,
4861: REQUEST_ID = FND_GLOBAL.conc_request_id,

Line 4859: CREATED_BY = FND_GLOBAL.user_id,

4855: -- WHO columns
4856: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4857: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4858: LAST_UPDATE_DATE = sysdate,
4859: CREATED_BY = FND_GLOBAL.user_id,
4860: CREATION_DATE = sysdate,
4861: REQUEST_ID = FND_GLOBAL.conc_request_id,
4862: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4863: PROGRAM_ID = FND_GLOBAL.conc_program_id,

Line 4861: REQUEST_ID = FND_GLOBAL.conc_request_id,

4857: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4858: LAST_UPDATE_DATE = sysdate,
4859: CREATED_BY = FND_GLOBAL.user_id,
4860: CREATION_DATE = sysdate,
4861: REQUEST_ID = FND_GLOBAL.conc_request_id,
4862: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4863: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4864: PROGRAM_UPDATE_DATE = sysdate,
4865: LAST_UPDATED_PROGRAM = d_mod

Line 4862: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

4858: LAST_UPDATE_DATE = sysdate,
4859: CREATED_BY = FND_GLOBAL.user_id,
4860: CREATION_DATE = sysdate,
4861: REQUEST_ID = FND_GLOBAL.conc_request_id,
4862: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4863: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4864: PROGRAM_UPDATE_DATE = sysdate,
4865: LAST_UPDATED_PROGRAM = d_mod
4866: WHERE po_line_id = NVL(p_po_line_id, -2)

Line 4863: PROGRAM_ID = FND_GLOBAL.conc_program_id,

4859: CREATED_BY = FND_GLOBAL.user_id,
4860: CREATION_DATE = sysdate,
4861: REQUEST_ID = FND_GLOBAL.conc_request_id,
4862: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4863: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4864: PROGRAM_UPDATE_DATE = sysdate,
4865: LAST_UPDATED_PROGRAM = d_mod
4866: WHERE po_line_id = NVL(p_po_line_id, -2)
4867: AND req_template_name = NVL(p_req_template_name, '-2')

Line 4907: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

4903: UPDATE PO_ATTRIBUTE_VALUES_TLP
4904: SET ip_category_id = p_ip_category_id,
4905: description = p_item_description,
4906: -- WHO columns
4907: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4908: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4909: LAST_UPDATE_DATE = sysdate,
4910: CREATED_BY = FND_GLOBAL.user_id,
4911: CREATION_DATE = sysdate,

Line 4908: LAST_UPDATED_BY = FND_GLOBAL.user_id,

4904: SET ip_category_id = p_ip_category_id,
4905: description = p_item_description,
4906: -- WHO columns
4907: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4908: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4909: LAST_UPDATE_DATE = sysdate,
4910: CREATED_BY = FND_GLOBAL.user_id,
4911: CREATION_DATE = sysdate,
4912: REQUEST_ID = FND_GLOBAL.conc_request_id,

Line 4910: CREATED_BY = FND_GLOBAL.user_id,

4906: -- WHO columns
4907: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4908: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4909: LAST_UPDATE_DATE = sysdate,
4910: CREATED_BY = FND_GLOBAL.user_id,
4911: CREATION_DATE = sysdate,
4912: REQUEST_ID = FND_GLOBAL.conc_request_id,
4913: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4914: PROGRAM_ID = FND_GLOBAL.conc_program_id,

Line 4912: REQUEST_ID = FND_GLOBAL.conc_request_id,

4908: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4909: LAST_UPDATE_DATE = sysdate,
4910: CREATED_BY = FND_GLOBAL.user_id,
4911: CREATION_DATE = sysdate,
4912: REQUEST_ID = FND_GLOBAL.conc_request_id,
4913: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4914: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4915: PROGRAM_UPDATE_DATE = sysdate,
4916: LAST_UPDATED_PROGRAM = d_mod

Line 4913: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

4909: LAST_UPDATE_DATE = sysdate,
4910: CREATED_BY = FND_GLOBAL.user_id,
4911: CREATION_DATE = sysdate,
4912: REQUEST_ID = FND_GLOBAL.conc_request_id,
4913: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4914: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4915: PROGRAM_UPDATE_DATE = sysdate,
4916: LAST_UPDATED_PROGRAM = d_mod
4917: WHERE po_line_id = NVL(p_po_line_id, -2)

Line 4914: PROGRAM_ID = FND_GLOBAL.conc_program_id,

4910: CREATED_BY = FND_GLOBAL.user_id,
4911: CREATION_DATE = sysdate,
4912: REQUEST_ID = FND_GLOBAL.conc_request_id,
4913: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4914: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4915: PROGRAM_UPDATE_DATE = sysdate,
4916: LAST_UPDATED_PROGRAM = d_mod
4917: WHERE po_line_id = NVL(p_po_line_id, -2)
4918: AND req_template_name = NVL(p_req_template_name, '-2')

Line 5624: FND_GLOBAL.login_id, -- last_update_login

5620: POATR.num_cat_attribute47,
5621: POATR.num_cat_attribute48,
5622: POATR.num_cat_attribute49,
5623: POATR.num_cat_attribute50,
5624: FND_GLOBAL.login_id, -- last_update_login
5625: FND_GLOBAL.user_id, -- last_updated_by
5626: sysdate, -- last_update_date
5627: POATR.created_by,
5628: POATR.creation_date,

Line 5625: FND_GLOBAL.user_id, -- last_updated_by

5621: POATR.num_cat_attribute48,
5622: POATR.num_cat_attribute49,
5623: POATR.num_cat_attribute50,
5624: FND_GLOBAL.login_id, -- last_update_login
5625: FND_GLOBAL.user_id, -- last_updated_by
5626: sysdate, -- last_update_date
5627: POATR.created_by,
5628: POATR.creation_date,
5629: FND_GLOBAL.conc_request_id, -- request_id

Line 5629: FND_GLOBAL.conc_request_id, -- request_id

5625: FND_GLOBAL.user_id, -- last_updated_by
5626: sysdate, -- last_update_date
5627: POATR.created_by,
5628: POATR.creation_date,
5629: FND_GLOBAL.conc_request_id, -- request_id
5630: POATR.program_application_id,
5631: POATR.program_id,
5632: POATR.program_update_date,
5633: d_mod -- last_updated_program

Line 5990: FND_GLOBAL.login_id, -- last_update_login

5986: POTLP.tl_text_cat_attribute47,
5987: POTLP.tl_text_cat_attribute48,
5988: POTLP.tl_text_cat_attribute49,
5989: POTLP.tl_text_cat_attribute50,
5990: FND_GLOBAL.login_id, -- last_update_login
5991: FND_GLOBAL.user_id, -- last_updated_by
5992: sysdate, -- last_update_date
5993: POTLP.created_by,
5994: POTLP.creation_date,

Line 5991: FND_GLOBAL.user_id, -- last_updated_by

5987: POTLP.tl_text_cat_attribute48,
5988: POTLP.tl_text_cat_attribute49,
5989: POTLP.tl_text_cat_attribute50,
5990: FND_GLOBAL.login_id, -- last_update_login
5991: FND_GLOBAL.user_id, -- last_updated_by
5992: sysdate, -- last_update_date
5993: POTLP.created_by,
5994: POTLP.creation_date,
5995: FND_GLOBAL.conc_request_id, -- request_id

Line 5995: FND_GLOBAL.conc_request_id, -- request_id

5991: FND_GLOBAL.user_id, -- last_updated_by
5992: sysdate, -- last_update_date
5993: POTLP.created_by,
5994: POTLP.creation_date,
5995: FND_GLOBAL.conc_request_id, -- request_id
5996: POTLP.program_application_id,
5997: POTLP.program_id,
5998: POTLP.program_update_date,
5999: d_mod -- last_updated_program

Line 6381: FND_GLOBAL.login_id, -- last_update_login

6377: l_description,
6378: l_long_description,
6379: l_manufacturer,
6380: -- WHO columns
6381: FND_GLOBAL.login_id, -- last_update_login
6382: FND_GLOBAL.user_id, -- last_updated_by
6383: sysdate, -- last_update_date
6384: FND_GLOBAL.user_id, -- created_by
6385: sysdate, -- creation_date

Line 6382: FND_GLOBAL.user_id, -- last_updated_by

6378: l_long_description,
6379: l_manufacturer,
6380: -- WHO columns
6381: FND_GLOBAL.login_id, -- last_update_login
6382: FND_GLOBAL.user_id, -- last_updated_by
6383: sysdate, -- last_update_date
6384: FND_GLOBAL.user_id, -- created_by
6385: sysdate, -- creation_date
6386: FND_GLOBAL.conc_request_id, -- request_id

Line 6384: FND_GLOBAL.user_id, -- created_by

6380: -- WHO columns
6381: FND_GLOBAL.login_id, -- last_update_login
6382: FND_GLOBAL.user_id, -- last_updated_by
6383: sysdate, -- last_update_date
6384: FND_GLOBAL.user_id, -- created_by
6385: sysdate, -- creation_date
6386: FND_GLOBAL.conc_request_id, -- request_id
6387: FND_GLOBAL.prog_appl_id, -- program_application_id
6388: FND_GLOBAL.conc_program_id, -- program_id

Line 6386: FND_GLOBAL.conc_request_id, -- request_id

6382: FND_GLOBAL.user_id, -- last_updated_by
6383: sysdate, -- last_update_date
6384: FND_GLOBAL.user_id, -- created_by
6385: sysdate, -- creation_date
6386: FND_GLOBAL.conc_request_id, -- request_id
6387: FND_GLOBAL.prog_appl_id, -- program_application_id
6388: FND_GLOBAL.conc_program_id, -- program_id
6389: sysdate, -- program_update_date
6390: d_mod -- last_updated_program

Line 6387: FND_GLOBAL.prog_appl_id, -- program_application_id

6383: sysdate, -- last_update_date
6384: FND_GLOBAL.user_id, -- created_by
6385: sysdate, -- creation_date
6386: FND_GLOBAL.conc_request_id, -- request_id
6387: FND_GLOBAL.prog_appl_id, -- program_application_id
6388: FND_GLOBAL.conc_program_id, -- program_id
6389: sysdate, -- program_update_date
6390: d_mod -- last_updated_program
6391: FROM DUAL

Line 6388: FND_GLOBAL.conc_program_id, -- program_id

6384: FND_GLOBAL.user_id, -- created_by
6385: sysdate, -- creation_date
6386: FND_GLOBAL.conc_request_id, -- request_id
6387: FND_GLOBAL.prog_appl_id, -- program_application_id
6388: FND_GLOBAL.conc_program_id, -- program_id
6389: sysdate, -- program_update_date
6390: d_mod -- last_updated_program
6391: FROM DUAL
6392: WHERE NOT EXISTS