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 3532: FND_GLOBAL.login_id, -- last_update_login

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

Line 3533: FND_GLOBAL.user_id, -- last_updated_by

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

Line 3535: FND_GLOBAL.user_id, -- created_by

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

Line 3537: FND_GLOBAL.conc_request_id, -- request_id

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

Line 3538: FND_GLOBAL.prog_appl_id, -- program_application_id

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

Line 3539: FND_GLOBAL.conc_program_id, -- program_id

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

Line 3699: FND_GLOBAL.login_id, -- last_update_login

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

Line 3700: FND_GLOBAL.user_id, -- last_updated_by

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

Line 3702: FND_GLOBAL.user_id, -- created_by

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

Line 3704: FND_GLOBAL.conc_request_id, -- request_id

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

Line 3705: FND_GLOBAL.prog_appl_id, -- program_application_id

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

Line 3706: FND_GLOBAL.conc_program_id, -- program_id

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

Line 3840: FND_GLOBAL.login_id, -- last_update_login

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

Line 3841: FND_GLOBAL.user_id, -- last_updated_by

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

Line 3843: FND_GLOBAL.user_id, -- created_by

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

Line 3845: FND_GLOBAL.conc_request_id, -- request_id

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

Line 3846: FND_GLOBAL.prog_appl_id, -- program_application_id

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

Line 3847: FND_GLOBAL.conc_program_id, -- program_id

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

Line 4001: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

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

Line 4002: LAST_UPDATED_BY = FND_GLOBAL.user_id,

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

Line 4004: CREATED_BY = FND_GLOBAL.user_id,

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

Line 4006: REQUEST_ID = FND_GLOBAL.conc_request_id,

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

Line 4007: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

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

Line 4008: PROGRAM_ID = FND_GLOBAL.conc_program_id,

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

Line 4076: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

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

Line 4077: LAST_UPDATED_BY = FND_GLOBAL.user_id,

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

Line 4079: CREATED_BY = FND_GLOBAL.user_id,

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

Line 4081: REQUEST_ID = FND_GLOBAL.conc_request_id,

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

Line 4082: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

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

Line 4083: PROGRAM_ID = FND_GLOBAL.conc_program_id,

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

Line 4248: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

4244: SET ip_category_id = p_ip_category_id,
4245: MANUFACTURER_PART_NUM = l_manufacturer_part_num,
4246: LEAD_TIME = l_proc_lead_time,
4247: -- WHO columns
4248: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4249: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4250: LAST_UPDATE_DATE = sysdate,
4251: CREATED_BY = FND_GLOBAL.user_id,
4252: CREATION_DATE = sysdate,

Line 4249: LAST_UPDATED_BY = FND_GLOBAL.user_id,

4245: MANUFACTURER_PART_NUM = l_manufacturer_part_num,
4246: LEAD_TIME = l_proc_lead_time,
4247: -- WHO columns
4248: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4249: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4250: LAST_UPDATE_DATE = sysdate,
4251: CREATED_BY = FND_GLOBAL.user_id,
4252: CREATION_DATE = sysdate,
4253: REQUEST_ID = FND_GLOBAL.conc_request_id,

Line 4251: CREATED_BY = FND_GLOBAL.user_id,

4247: -- WHO columns
4248: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4249: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4250: LAST_UPDATE_DATE = sysdate,
4251: CREATED_BY = FND_GLOBAL.user_id,
4252: CREATION_DATE = sysdate,
4253: REQUEST_ID = FND_GLOBAL.conc_request_id,
4254: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4255: PROGRAM_ID = FND_GLOBAL.conc_program_id,

Line 4253: REQUEST_ID = FND_GLOBAL.conc_request_id,

4249: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4250: LAST_UPDATE_DATE = sysdate,
4251: CREATED_BY = FND_GLOBAL.user_id,
4252: CREATION_DATE = sysdate,
4253: REQUEST_ID = FND_GLOBAL.conc_request_id,
4254: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4255: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4256: PROGRAM_UPDATE_DATE = sysdate,
4257: LAST_UPDATED_PROGRAM = d_mod

Line 4254: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

4250: LAST_UPDATE_DATE = sysdate,
4251: CREATED_BY = FND_GLOBAL.user_id,
4252: CREATION_DATE = sysdate,
4253: REQUEST_ID = FND_GLOBAL.conc_request_id,
4254: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4255: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4256: PROGRAM_UPDATE_DATE = sysdate,
4257: LAST_UPDATED_PROGRAM = d_mod
4258: WHERE po_line_id = -2

Line 4255: PROGRAM_ID = FND_GLOBAL.conc_program_id,

4251: CREATED_BY = FND_GLOBAL.user_id,
4252: CREATION_DATE = sysdate,
4253: REQUEST_ID = FND_GLOBAL.conc_request_id,
4254: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4255: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4256: PROGRAM_UPDATE_DATE = sysdate,
4257: LAST_UPDATED_PROGRAM = d_mod
4258: WHERE po_line_id = -2
4259: AND req_template_name = '-2'

Line 4338: FND_GLOBAL.login_id, -- last_update_login

4334: p_inventory_item_id,
4335: p_org_id,
4336: l_manufacturer,
4337: l_new_long_description,
4338: FND_GLOBAL.login_id, -- last_update_login
4339: FND_GLOBAL.user_id, -- last_updated_by
4340: sysdate, -- last_update_date
4341: FND_GLOBAL.user_id, -- created_by
4342: sysdate, -- creation_date

Line 4339: FND_GLOBAL.user_id, -- last_updated_by

4335: p_org_id,
4336: l_manufacturer,
4337: l_new_long_description,
4338: FND_GLOBAL.login_id, -- last_update_login
4339: FND_GLOBAL.user_id, -- last_updated_by
4340: sysdate, -- last_update_date
4341: FND_GLOBAL.user_id, -- created_by
4342: sysdate, -- creation_date
4343: FND_GLOBAL.conc_request_id, -- request_id

Line 4341: FND_GLOBAL.user_id, -- created_by

4337: l_new_long_description,
4338: FND_GLOBAL.login_id, -- last_update_login
4339: FND_GLOBAL.user_id, -- last_updated_by
4340: sysdate, -- last_update_date
4341: FND_GLOBAL.user_id, -- created_by
4342: sysdate, -- creation_date
4343: FND_GLOBAL.conc_request_id, -- request_id
4344: FND_GLOBAL.prog_appl_id,
4345: FND_GLOBAL.conc_program_id, -- program_id

Line 4343: FND_GLOBAL.conc_request_id, -- request_id

4339: FND_GLOBAL.user_id, -- last_updated_by
4340: sysdate, -- last_update_date
4341: FND_GLOBAL.user_id, -- created_by
4342: sysdate, -- creation_date
4343: FND_GLOBAL.conc_request_id, -- request_id
4344: FND_GLOBAL.prog_appl_id,
4345: FND_GLOBAL.conc_program_id, -- program_id
4346: sysdate, -- program_update_date
4347: d_mod -- last_updated_program

Line 4344: FND_GLOBAL.prog_appl_id,

4340: sysdate, -- last_update_date
4341: FND_GLOBAL.user_id, -- created_by
4342: sysdate, -- creation_date
4343: FND_GLOBAL.conc_request_id, -- request_id
4344: FND_GLOBAL.prog_appl_id,
4345: FND_GLOBAL.conc_program_id, -- program_id
4346: sysdate, -- program_update_date
4347: d_mod -- last_updated_program
4348: FROM dual;

Line 4345: FND_GLOBAL.conc_program_id, -- program_id

4341: FND_GLOBAL.user_id, -- created_by
4342: sysdate, -- creation_date
4343: FND_GLOBAL.conc_request_id, -- request_id
4344: FND_GLOBAL.prog_appl_id,
4345: FND_GLOBAL.conc_program_id, -- program_id
4346: sysdate, -- program_update_date
4347: d_mod -- last_updated_program
4348: FROM dual;
4349:

Line 4384: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

4380: description = p_item_description,
4381: manufacturer = l_manufacturer,
4382: long_description = l_new_long_description,
4383: -- WHO columns
4384: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4385: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4386: LAST_UPDATE_DATE = sysdate,
4387: CREATED_BY = FND_GLOBAL.user_id,
4388: CREATION_DATE = sysdate,

Line 4385: LAST_UPDATED_BY = FND_GLOBAL.user_id,

4381: manufacturer = l_manufacturer,
4382: long_description = l_new_long_description,
4383: -- WHO columns
4384: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4385: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4386: LAST_UPDATE_DATE = sysdate,
4387: CREATED_BY = FND_GLOBAL.user_id,
4388: CREATION_DATE = sysdate,
4389: REQUEST_ID = FND_GLOBAL.conc_request_id,

Line 4387: CREATED_BY = FND_GLOBAL.user_id,

4383: -- WHO columns
4384: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4385: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4386: LAST_UPDATE_DATE = sysdate,
4387: CREATED_BY = FND_GLOBAL.user_id,
4388: CREATION_DATE = sysdate,
4389: REQUEST_ID = FND_GLOBAL.conc_request_id,
4390: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4391: PROGRAM_ID = FND_GLOBAL.conc_program_id,

Line 4389: REQUEST_ID = FND_GLOBAL.conc_request_id,

4385: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4386: LAST_UPDATE_DATE = sysdate,
4387: CREATED_BY = FND_GLOBAL.user_id,
4388: CREATION_DATE = sysdate,
4389: REQUEST_ID = FND_GLOBAL.conc_request_id,
4390: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4391: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4392: PROGRAM_UPDATE_DATE = sysdate,
4393: LAST_UPDATED_PROGRAM = d_mod

Line 4390: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

4386: LAST_UPDATE_DATE = sysdate,
4387: CREATED_BY = FND_GLOBAL.user_id,
4388: CREATION_DATE = sysdate,
4389: REQUEST_ID = FND_GLOBAL.conc_request_id,
4390: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4391: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4392: PROGRAM_UPDATE_DATE = sysdate,
4393: LAST_UPDATED_PROGRAM = d_mod
4394: WHERE po_line_id = -2

Line 4391: PROGRAM_ID = FND_GLOBAL.conc_program_id,

4387: CREATED_BY = FND_GLOBAL.user_id,
4388: CREATION_DATE = sysdate,
4389: REQUEST_ID = FND_GLOBAL.conc_request_id,
4390: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4391: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4392: PROGRAM_UPDATE_DATE = sysdate,
4393: LAST_UPDATED_PROGRAM = d_mod
4394: WHERE po_line_id = -2
4395: AND req_template_name = '-2'

Line 4660: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

4656: TEXT_CAT_ATTRIBUTE48 = NULL,
4657: TEXT_CAT_ATTRIBUTE49 = NULL,
4658: TEXT_CAT_ATTRIBUTE50 = NULL,
4659: -- WHO columns
4660: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4661: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4662: LAST_UPDATE_DATE = sysdate,
4663: CREATED_BY = FND_GLOBAL.user_id,
4664: CREATION_DATE = sysdate,

Line 4661: LAST_UPDATED_BY = FND_GLOBAL.user_id,

4657: TEXT_CAT_ATTRIBUTE49 = NULL,
4658: TEXT_CAT_ATTRIBUTE50 = NULL,
4659: -- WHO columns
4660: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4661: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4662: LAST_UPDATE_DATE = sysdate,
4663: CREATED_BY = FND_GLOBAL.user_id,
4664: CREATION_DATE = sysdate,
4665: REQUEST_ID = FND_GLOBAL.conc_request_id,

Line 4663: CREATED_BY = FND_GLOBAL.user_id,

4659: -- WHO columns
4660: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4661: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4662: LAST_UPDATE_DATE = sysdate,
4663: CREATED_BY = FND_GLOBAL.user_id,
4664: CREATION_DATE = sysdate,
4665: REQUEST_ID = FND_GLOBAL.conc_request_id,
4666: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4667: PROGRAM_ID = FND_GLOBAL.conc_program_id,

Line 4665: REQUEST_ID = FND_GLOBAL.conc_request_id,

4661: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4662: LAST_UPDATE_DATE = sysdate,
4663: CREATED_BY = FND_GLOBAL.user_id,
4664: CREATION_DATE = sysdate,
4665: REQUEST_ID = FND_GLOBAL.conc_request_id,
4666: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4667: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4668: PROGRAM_UPDATE_DATE = sysdate,
4669: LAST_UPDATED_PROGRAM = d_mod

Line 4666: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

4662: LAST_UPDATE_DATE = sysdate,
4663: CREATED_BY = FND_GLOBAL.user_id,
4664: CREATION_DATE = sysdate,
4665: REQUEST_ID = FND_GLOBAL.conc_request_id,
4666: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4667: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4668: PROGRAM_UPDATE_DATE = sysdate,
4669: LAST_UPDATED_PROGRAM = d_mod
4670: WHERE po_line_id = NVL(p_po_line_id, -2)

Line 4667: PROGRAM_ID = FND_GLOBAL.conc_program_id,

4663: CREATED_BY = FND_GLOBAL.user_id,
4664: CREATION_DATE = sysdate,
4665: REQUEST_ID = FND_GLOBAL.conc_request_id,
4666: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4667: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4668: PROGRAM_UPDATE_DATE = sysdate,
4669: LAST_UPDATED_PROGRAM = d_mod
4670: WHERE po_line_id = NVL(p_po_line_id, -2)
4671: AND req_template_name = NVL(p_req_template_name, '-2')

Line 4734: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

4730: TL_TEXT_CAT_ATTRIBUTE48 = NULL,
4731: TL_TEXT_CAT_ATTRIBUTE49 = NULL,
4732: TL_TEXT_CAT_ATTRIBUTE50 = NULL,
4733: -- WHO columns
4734: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4735: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4736: LAST_UPDATE_DATE = sysdate,
4737: CREATED_BY = FND_GLOBAL.user_id,
4738: CREATION_DATE = sysdate,

Line 4735: LAST_UPDATED_BY = FND_GLOBAL.user_id,

4731: TL_TEXT_CAT_ATTRIBUTE49 = NULL,
4732: TL_TEXT_CAT_ATTRIBUTE50 = NULL,
4733: -- WHO columns
4734: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4735: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4736: LAST_UPDATE_DATE = sysdate,
4737: CREATED_BY = FND_GLOBAL.user_id,
4738: CREATION_DATE = sysdate,
4739: REQUEST_ID = FND_GLOBAL.conc_request_id,

Line 4737: CREATED_BY = FND_GLOBAL.user_id,

4733: -- WHO columns
4734: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4735: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4736: LAST_UPDATE_DATE = sysdate,
4737: CREATED_BY = FND_GLOBAL.user_id,
4738: CREATION_DATE = sysdate,
4739: REQUEST_ID = FND_GLOBAL.conc_request_id,
4740: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4741: PROGRAM_ID = FND_GLOBAL.conc_program_id,

Line 4739: REQUEST_ID = FND_GLOBAL.conc_request_id,

4735: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4736: LAST_UPDATE_DATE = sysdate,
4737: CREATED_BY = FND_GLOBAL.user_id,
4738: CREATION_DATE = sysdate,
4739: REQUEST_ID = FND_GLOBAL.conc_request_id,
4740: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4741: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4742: PROGRAM_UPDATE_DATE = sysdate,
4743: LAST_UPDATED_PROGRAM = d_mod

Line 4740: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

4736: LAST_UPDATE_DATE = sysdate,
4737: CREATED_BY = FND_GLOBAL.user_id,
4738: CREATION_DATE = sysdate,
4739: REQUEST_ID = FND_GLOBAL.conc_request_id,
4740: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4741: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4742: PROGRAM_UPDATE_DATE = sysdate,
4743: LAST_UPDATED_PROGRAM = d_mod
4744: WHERE po_line_id = NVL(p_po_line_id, -2)

Line 4741: PROGRAM_ID = FND_GLOBAL.conc_program_id,

4737: CREATED_BY = FND_GLOBAL.user_id,
4738: CREATION_DATE = sysdate,
4739: REQUEST_ID = FND_GLOBAL.conc_request_id,
4740: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4741: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4742: PROGRAM_UPDATE_DATE = sysdate,
4743: LAST_UPDATED_PROGRAM = d_mod
4744: WHERE po_line_id = NVL(p_po_line_id, -2)
4745: AND req_template_name = NVL(p_req_template_name, '-2')

Line 4882: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

4878: -- SQL Join: po_line_id, req_template_name, req_template_line_num, org_id
4879: UPDATE PO_ATTRIBUTE_VALUES
4880: SET ip_category_id = p_ip_category_id,
4881: -- WHO columns
4882: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4883: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4884: LAST_UPDATE_DATE = sysdate,
4885: CREATED_BY = FND_GLOBAL.user_id,
4886: CREATION_DATE = sysdate,

Line 4883: LAST_UPDATED_BY = FND_GLOBAL.user_id,

4879: UPDATE PO_ATTRIBUTE_VALUES
4880: SET ip_category_id = p_ip_category_id,
4881: -- WHO columns
4882: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4883: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4884: LAST_UPDATE_DATE = sysdate,
4885: CREATED_BY = FND_GLOBAL.user_id,
4886: CREATION_DATE = sysdate,
4887: REQUEST_ID = FND_GLOBAL.conc_request_id,

Line 4885: CREATED_BY = FND_GLOBAL.user_id,

4881: -- WHO columns
4882: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4883: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4884: LAST_UPDATE_DATE = sysdate,
4885: CREATED_BY = FND_GLOBAL.user_id,
4886: CREATION_DATE = sysdate,
4887: REQUEST_ID = FND_GLOBAL.conc_request_id,
4888: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4889: PROGRAM_ID = FND_GLOBAL.conc_program_id,

Line 4887: REQUEST_ID = FND_GLOBAL.conc_request_id,

4883: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4884: LAST_UPDATE_DATE = sysdate,
4885: CREATED_BY = FND_GLOBAL.user_id,
4886: CREATION_DATE = sysdate,
4887: REQUEST_ID = FND_GLOBAL.conc_request_id,
4888: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4889: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4890: PROGRAM_UPDATE_DATE = sysdate,
4891: LAST_UPDATED_PROGRAM = d_mod

Line 4888: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

4884: LAST_UPDATE_DATE = sysdate,
4885: CREATED_BY = FND_GLOBAL.user_id,
4886: CREATION_DATE = sysdate,
4887: REQUEST_ID = FND_GLOBAL.conc_request_id,
4888: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4889: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4890: PROGRAM_UPDATE_DATE = sysdate,
4891: LAST_UPDATED_PROGRAM = d_mod
4892: WHERE po_line_id = NVL(p_po_line_id, -2)

Line 4889: PROGRAM_ID = FND_GLOBAL.conc_program_id,

4885: CREATED_BY = FND_GLOBAL.user_id,
4886: CREATION_DATE = sysdate,
4887: REQUEST_ID = FND_GLOBAL.conc_request_id,
4888: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4889: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4890: PROGRAM_UPDATE_DATE = sysdate,
4891: LAST_UPDATED_PROGRAM = d_mod
4892: WHERE po_line_id = NVL(p_po_line_id, -2)
4893: AND req_template_name = NVL(p_req_template_name, '-2')

Line 4943: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

4939: UPDATE PO_ATTRIBUTE_VALUES_TLP
4940: SET ip_category_id = p_ip_category_id,
4941: description = p_item_description,
4942: -- WHO columns
4943: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4944: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4945: LAST_UPDATE_DATE = sysdate,
4946: CREATED_BY = FND_GLOBAL.user_id,
4947: CREATION_DATE = sysdate,

Line 4944: LAST_UPDATED_BY = FND_GLOBAL.user_id,

4940: SET ip_category_id = p_ip_category_id,
4941: description = p_item_description,
4942: -- WHO columns
4943: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4944: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4945: LAST_UPDATE_DATE = sysdate,
4946: CREATED_BY = FND_GLOBAL.user_id,
4947: CREATION_DATE = sysdate,
4948: REQUEST_ID = FND_GLOBAL.conc_request_id,

Line 4946: CREATED_BY = FND_GLOBAL.user_id,

4942: -- WHO columns
4943: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4944: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4945: LAST_UPDATE_DATE = sysdate,
4946: CREATED_BY = FND_GLOBAL.user_id,
4947: CREATION_DATE = sysdate,
4948: REQUEST_ID = FND_GLOBAL.conc_request_id,
4949: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4950: PROGRAM_ID = FND_GLOBAL.conc_program_id,

Line 4948: REQUEST_ID = FND_GLOBAL.conc_request_id,

4944: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4945: LAST_UPDATE_DATE = sysdate,
4946: CREATED_BY = FND_GLOBAL.user_id,
4947: CREATION_DATE = sysdate,
4948: REQUEST_ID = FND_GLOBAL.conc_request_id,
4949: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4950: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4951: PROGRAM_UPDATE_DATE = sysdate,
4952: LAST_UPDATED_PROGRAM = d_mod

Line 4949: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

4945: LAST_UPDATE_DATE = sysdate,
4946: CREATED_BY = FND_GLOBAL.user_id,
4947: CREATION_DATE = sysdate,
4948: REQUEST_ID = FND_GLOBAL.conc_request_id,
4949: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4950: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4951: PROGRAM_UPDATE_DATE = sysdate,
4952: LAST_UPDATED_PROGRAM = d_mod
4953: WHERE po_line_id = NVL(p_po_line_id, -2)

Line 4950: PROGRAM_ID = FND_GLOBAL.conc_program_id,

4946: CREATED_BY = FND_GLOBAL.user_id,
4947: CREATION_DATE = sysdate,
4948: REQUEST_ID = FND_GLOBAL.conc_request_id,
4949: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4950: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4951: PROGRAM_UPDATE_DATE = sysdate,
4952: LAST_UPDATED_PROGRAM = d_mod
4953: WHERE po_line_id = NVL(p_po_line_id, -2)
4954: AND req_template_name = NVL(p_req_template_name, '-2')

Line 4992: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

4988: -- SQL Join: po_line_id, req_template_name, req_template_line_num, org_id, language
4989: UPDATE PO_ATTRIBUTE_VALUES_TLP
4990: SET long_description = l_long_description,
4991: -- WHO columns
4992: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4993: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4994: LAST_UPDATE_DATE = sysdate,
4995: REQUEST_ID = FND_GLOBAL.conc_request_id,
4996: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

Line 4993: LAST_UPDATED_BY = FND_GLOBAL.user_id,

4989: UPDATE PO_ATTRIBUTE_VALUES_TLP
4990: SET long_description = l_long_description,
4991: -- WHO columns
4992: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4993: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4994: LAST_UPDATE_DATE = sysdate,
4995: REQUEST_ID = FND_GLOBAL.conc_request_id,
4996: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4997: PROGRAM_ID = FND_GLOBAL.conc_program_id,

Line 4995: REQUEST_ID = FND_GLOBAL.conc_request_id,

4991: -- WHO columns
4992: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4993: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4994: LAST_UPDATE_DATE = sysdate,
4995: REQUEST_ID = FND_GLOBAL.conc_request_id,
4996: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4997: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4998: PROGRAM_UPDATE_DATE = sysdate,
4999: LAST_UPDATED_PROGRAM = d_mod

Line 4996: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

4992: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
4993: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4994: LAST_UPDATE_DATE = sysdate,
4995: REQUEST_ID = FND_GLOBAL.conc_request_id,
4996: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4997: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4998: PROGRAM_UPDATE_DATE = sysdate,
4999: LAST_UPDATED_PROGRAM = d_mod
5000: WHERE po_line_id = NVL(p_po_line_id, -2)

Line 4997: PROGRAM_ID = FND_GLOBAL.conc_program_id,

4993: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4994: LAST_UPDATE_DATE = sysdate,
4995: REQUEST_ID = FND_GLOBAL.conc_request_id,
4996: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
4997: PROGRAM_ID = FND_GLOBAL.conc_program_id,
4998: PROGRAM_UPDATE_DATE = sysdate,
4999: LAST_UPDATED_PROGRAM = d_mod
5000: WHERE po_line_id = NVL(p_po_line_id, -2)
5001: AND req_template_name = NVL(p_req_template_name, '-2')

Line 5038: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

5034: -- SQL Join: po_line_id, req_template_name, req_template_line_num, org_id
5035: UPDATE PO_ATTRIBUTE_VALUES
5036: SET lead_time = l_lead_time,
5037: -- WHO columns
5038: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
5039: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5040: LAST_UPDATE_DATE = sysdate,
5041: REQUEST_ID = FND_GLOBAL.conc_request_id,
5042: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

Line 5039: LAST_UPDATED_BY = FND_GLOBAL.user_id,

5035: UPDATE PO_ATTRIBUTE_VALUES
5036: SET lead_time = l_lead_time,
5037: -- WHO columns
5038: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
5039: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5040: LAST_UPDATE_DATE = sysdate,
5041: REQUEST_ID = FND_GLOBAL.conc_request_id,
5042: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
5043: PROGRAM_ID = FND_GLOBAL.conc_program_id,

Line 5041: REQUEST_ID = FND_GLOBAL.conc_request_id,

5037: -- WHO columns
5038: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
5039: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5040: LAST_UPDATE_DATE = sysdate,
5041: REQUEST_ID = FND_GLOBAL.conc_request_id,
5042: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
5043: PROGRAM_ID = FND_GLOBAL.conc_program_id,
5044: PROGRAM_UPDATE_DATE = sysdate,
5045: LAST_UPDATED_PROGRAM = d_mod

Line 5042: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

5038: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
5039: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5040: LAST_UPDATE_DATE = sysdate,
5041: REQUEST_ID = FND_GLOBAL.conc_request_id,
5042: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
5043: PROGRAM_ID = FND_GLOBAL.conc_program_id,
5044: PROGRAM_UPDATE_DATE = sysdate,
5045: LAST_UPDATED_PROGRAM = d_mod
5046: WHERE po_line_id = NVL(p_po_line_id, -2)

Line 5043: PROGRAM_ID = FND_GLOBAL.conc_program_id,

5039: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5040: LAST_UPDATE_DATE = sysdate,
5041: REQUEST_ID = FND_GLOBAL.conc_request_id,
5042: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
5043: PROGRAM_ID = FND_GLOBAL.conc_program_id,
5044: PROGRAM_UPDATE_DATE = sysdate,
5045: LAST_UPDATED_PROGRAM = d_mod
5046: WHERE po_line_id = NVL(p_po_line_id, -2)
5047: AND req_template_name = NVL(p_req_template_name, '-2')

Line 5755: FND_GLOBAL.login_id, -- last_update_login

5751: POATR.num_cat_attribute47,
5752: POATR.num_cat_attribute48,
5753: POATR.num_cat_attribute49,
5754: POATR.num_cat_attribute50,
5755: FND_GLOBAL.login_id, -- last_update_login
5756: FND_GLOBAL.user_id, -- last_updated_by
5757: sysdate, -- last_update_date
5758: POATR.created_by,
5759: POATR.creation_date,

Line 5756: FND_GLOBAL.user_id, -- last_updated_by

5752: POATR.num_cat_attribute48,
5753: POATR.num_cat_attribute49,
5754: POATR.num_cat_attribute50,
5755: FND_GLOBAL.login_id, -- last_update_login
5756: FND_GLOBAL.user_id, -- last_updated_by
5757: sysdate, -- last_update_date
5758: POATR.created_by,
5759: POATR.creation_date,
5760: FND_GLOBAL.conc_request_id, -- request_id

Line 5760: FND_GLOBAL.conc_request_id, -- request_id

5756: FND_GLOBAL.user_id, -- last_updated_by
5757: sysdate, -- last_update_date
5758: POATR.created_by,
5759: POATR.creation_date,
5760: FND_GLOBAL.conc_request_id, -- request_id
5761: POATR.program_application_id,
5762: POATR.program_id,
5763: POATR.program_update_date,
5764: d_mod -- last_updated_program

Line 6122: FND_GLOBAL.login_id, -- last_update_login

6118: POTLP.tl_text_cat_attribute47,
6119: POTLP.tl_text_cat_attribute48,
6120: POTLP.tl_text_cat_attribute49,
6121: POTLP.tl_text_cat_attribute50,
6122: FND_GLOBAL.login_id, -- last_update_login
6123: FND_GLOBAL.user_id, -- last_updated_by
6124: sysdate, -- last_update_date
6125: POTLP.created_by,
6126: POTLP.creation_date,

Line 6123: FND_GLOBAL.user_id, -- last_updated_by

6119: POTLP.tl_text_cat_attribute48,
6120: POTLP.tl_text_cat_attribute49,
6121: POTLP.tl_text_cat_attribute50,
6122: FND_GLOBAL.login_id, -- last_update_login
6123: FND_GLOBAL.user_id, -- last_updated_by
6124: sysdate, -- last_update_date
6125: POTLP.created_by,
6126: POTLP.creation_date,
6127: FND_GLOBAL.conc_request_id, -- request_id

Line 6127: FND_GLOBAL.conc_request_id, -- request_id

6123: FND_GLOBAL.user_id, -- last_updated_by
6124: sysdate, -- last_update_date
6125: POTLP.created_by,
6126: POTLP.creation_date,
6127: FND_GLOBAL.conc_request_id, -- request_id
6128: POTLP.program_application_id,
6129: POTLP.program_id,
6130: POTLP.program_update_date,
6131: d_mod -- last_updated_program

Line 6514: FND_GLOBAL.login_id, -- last_update_login

6510: l_description,
6511: l_long_description,
6512: l_manufacturer,
6513: -- WHO columns
6514: FND_GLOBAL.login_id, -- last_update_login
6515: FND_GLOBAL.user_id, -- last_updated_by
6516: sysdate, -- last_update_date
6517: FND_GLOBAL.user_id, -- created_by
6518: sysdate, -- creation_date

Line 6515: FND_GLOBAL.user_id, -- last_updated_by

6511: l_long_description,
6512: l_manufacturer,
6513: -- WHO columns
6514: FND_GLOBAL.login_id, -- last_update_login
6515: FND_GLOBAL.user_id, -- last_updated_by
6516: sysdate, -- last_update_date
6517: FND_GLOBAL.user_id, -- created_by
6518: sysdate, -- creation_date
6519: FND_GLOBAL.conc_request_id, -- request_id

Line 6517: FND_GLOBAL.user_id, -- created_by

6513: -- WHO columns
6514: FND_GLOBAL.login_id, -- last_update_login
6515: FND_GLOBAL.user_id, -- last_updated_by
6516: sysdate, -- last_update_date
6517: FND_GLOBAL.user_id, -- created_by
6518: sysdate, -- creation_date
6519: FND_GLOBAL.conc_request_id, -- request_id
6520: FND_GLOBAL.prog_appl_id, -- program_application_id
6521: FND_GLOBAL.conc_program_id, -- program_id

Line 6519: FND_GLOBAL.conc_request_id, -- request_id

6515: FND_GLOBAL.user_id, -- last_updated_by
6516: sysdate, -- last_update_date
6517: FND_GLOBAL.user_id, -- created_by
6518: sysdate, -- creation_date
6519: FND_GLOBAL.conc_request_id, -- request_id
6520: FND_GLOBAL.prog_appl_id, -- program_application_id
6521: FND_GLOBAL.conc_program_id, -- program_id
6522: sysdate, -- program_update_date
6523: d_mod -- last_updated_program

Line 6520: FND_GLOBAL.prog_appl_id, -- program_application_id

6516: sysdate, -- last_update_date
6517: FND_GLOBAL.user_id, -- created_by
6518: sysdate, -- creation_date
6519: FND_GLOBAL.conc_request_id, -- request_id
6520: FND_GLOBAL.prog_appl_id, -- program_application_id
6521: FND_GLOBAL.conc_program_id, -- program_id
6522: sysdate, -- program_update_date
6523: d_mod -- last_updated_program
6524: FROM DUAL

Line 6521: FND_GLOBAL.conc_program_id, -- program_id

6517: FND_GLOBAL.user_id, -- created_by
6518: sysdate, -- creation_date
6519: FND_GLOBAL.conc_request_id, -- request_id
6520: FND_GLOBAL.prog_appl_id, -- program_application_id
6521: FND_GLOBAL.conc_program_id, -- program_id
6522: sysdate, -- program_update_date
6523: d_mod -- last_updated_program
6524: FROM DUAL
6525: WHERE NOT EXISTS