APPS.PA_MASS_ADDITIONS_CREATE_PKG dependencies on FND_GLOBAL

Line 645: program_application_id = FND_GLOBAL.prog_appl_id,

641: FORALL i in Flag_no_eiIDTab.FIRST..Flag_no_eiIDTab.LAST
642: UPDATE pa_cost_distribution_lines
643: SET si_assets_addition_flag = 'N',
644: program_update_date = SYSDATE,
645: program_application_id = FND_GLOBAL.prog_appl_id,
646: program_id = FND_GLOBAL.conc_program_id,
647: request_id = p_request_id
648: WHERE si_assets_addition_flag = 'T'
649: AND expenditure_item_id = Flag_no_eiIDTab(i)

Line 646: program_id = FND_GLOBAL.conc_program_id,

642: UPDATE pa_cost_distribution_lines
643: SET si_assets_addition_flag = 'N',
644: program_update_date = SYSDATE,
645: program_application_id = FND_GLOBAL.prog_appl_id,
646: program_id = FND_GLOBAL.conc_program_id,
647: request_id = p_request_id
648: WHERE si_assets_addition_flag = 'T'
649: AND expenditure_item_id = Flag_no_eiIDTab(i)
650: AND line_num = Flag_no_lineNumTab(i);

Line 1262: program_application_id = FND_GLOBAL.prog_appl_id,

1258: FORALL i in Flag_no_eiIDTab.FIRST..Flag_no_eiIDTab.LAST
1259: UPDATE pa_cost_distribution_lines
1260: SET si_assets_addition_flag = 'N',
1261: program_update_date = SYSDATE,
1262: program_application_id = FND_GLOBAL.prog_appl_id,
1263: program_id = FND_GLOBAL.conc_program_id,
1264: request_id = p_request_id
1265: WHERE si_assets_addition_flag in ('T', 'O')
1266: AND expenditure_item_id = Flag_no_eiIDTab(i)

Line 1263: program_id = FND_GLOBAL.conc_program_id,

1259: UPDATE pa_cost_distribution_lines
1260: SET si_assets_addition_flag = 'N',
1261: program_update_date = SYSDATE,
1262: program_application_id = FND_GLOBAL.prog_appl_id,
1263: program_id = FND_GLOBAL.conc_program_id,
1264: request_id = p_request_id
1265: WHERE si_assets_addition_flag in ('T', 'O')
1266: AND expenditure_item_id = Flag_no_eiIDTab(i)
1267: AND line_num = Flag_no_lineNumTab(i);

Line 1492: program_application_id = FND_GLOBAL.prog_appl_id,

1488: --
1489: UPDATE pa_cost_distribution_lines
1490: SET si_assets_addition_flag = 'Y',
1491: program_update_date = SYSDATE,
1492: program_application_id = FND_GLOBAL.prog_appl_id,
1493: program_id = FND_GLOBAL.conc_program_id,
1494: request_id = p_request_id
1495: where si_assets_addition_flag = ('T')
1496: AND (expenditure_item_id, line_num ) in

Line 1493: program_id = FND_GLOBAL.conc_program_id,

1489: UPDATE pa_cost_distribution_lines
1490: SET si_assets_addition_flag = 'Y',
1491: program_update_date = SYSDATE,
1492: program_application_id = FND_GLOBAL.prog_appl_id,
1493: program_id = FND_GLOBAL.conc_program_id,
1494: request_id = p_request_id
1495: where si_assets_addition_flag = ('T')
1496: AND (expenditure_item_id, line_num ) in
1497: (SELECT expenditure_item_id, line_num

Line 1513: program_application_id = FND_GLOBAL.prog_appl_id,

1509: --
1510: UPDATE pa_cost_distribution_lines
1511: SET si_assets_addition_flag = 'N',
1512: program_update_date = SYSDATE,
1513: program_application_id = FND_GLOBAL.prog_appl_id,
1514: program_id = FND_GLOBAL.conc_program_id,
1515: request_id = p_request_id
1516: where si_assets_addition_flag = ('T')
1517: AND (expenditure_item_id, line_num ) in

Line 1514: program_id = FND_GLOBAL.conc_program_id,

1510: UPDATE pa_cost_distribution_lines
1511: SET si_assets_addition_flag = 'N',
1512: program_update_date = SYSDATE,
1513: program_application_id = FND_GLOBAL.prog_appl_id,
1514: program_id = FND_GLOBAL.conc_program_id,
1515: request_id = p_request_id
1516: where si_assets_addition_flag = ('T')
1517: AND (expenditure_item_id, line_num ) in
1518: (SELECT expenditure_item_id, line_num

Line 1866: program_application_id = FND_GLOBAL.prog_appl_id,

1862: FORALL i in Flag_no_eiIDTab.FIRST..Flag_no_eiIDTab.LAST
1863: UPDATE pa_cost_distribution_lines
1864: SET si_assets_addition_flag = 'N',
1865: program_update_date = SYSDATE,
1866: program_application_id = FND_GLOBAL.prog_appl_id,
1867: program_id = FND_GLOBAL.conc_program_id,
1868: request_id = p_request_id
1869: WHERE si_assets_addition_flag in ('T')
1870: AND expenditure_item_id = Flag_no_eiIDTab(i)

Line 1867: program_id = FND_GLOBAL.conc_program_id,

1863: UPDATE pa_cost_distribution_lines
1864: SET si_assets_addition_flag = 'N',
1865: program_update_date = SYSDATE,
1866: program_application_id = FND_GLOBAL.prog_appl_id,
1867: program_id = FND_GLOBAL.conc_program_id,
1868: request_id = p_request_id
1869: WHERE si_assets_addition_flag in ('T')
1870: AND expenditure_item_id = Flag_no_eiIDTab(i)
1871: AND line_num = Flag_no_lineNumTab(i);