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

Line 481: ' where user_name=fnd_global.user_name;'||

477: ' l_application_id number;'||
478: ' begin'||
479: ' select user_id into l_user_id'||
480: ' from '||l_apps_schema||'.fnd_user'||l_suffix||
481: ' where user_name=fnd_global.user_name;'||
482: ' '||
483: ' select responsibility_id into l_responsibility_id'||
484: ' from '||l_apps_schema||'.fnd_responsibility'||l_suffix||
485: ' where responsibility_key=('||

Line 487: ' where responsibility_id=fnd_global.resp_id);'||

483: ' select responsibility_id into l_responsibility_id'||
484: ' from '||l_apps_schema||'.fnd_responsibility'||l_suffix||
485: ' where responsibility_key=('||
486: ' select responsibility_key from fnd_responsibility'||
487: ' where responsibility_id=fnd_global.resp_id);'||
488: ' '||
489: ' select application_id into l_application_id'||
490: ' from '||l_apps_schema||'.fnd_application'||l_suffix||
491: ' where application_short_name=fnd_global.application_short_name;'||

Line 491: ' where application_short_name=fnd_global.application_short_name;'||

487: ' where responsibility_id=fnd_global.resp_id);'||
488: ' '||
489: ' select application_id into l_application_id'||
490: ' from '||l_apps_schema||'.fnd_application'||l_suffix||
491: ' where application_short_name=fnd_global.application_short_name;'||
492: ' '||
493: ' '||l_apps_schema||'.fnd_global.apps_initialize'||l_suffix||'('||
494: ' l_user_id, l_responsibility_id, l_application_id);'||
495: ' '||p_sql||

Line 493: ' '||l_apps_schema||'.fnd_global.apps_initialize'||l_suffix||'('||

489: ' select application_id into l_application_id'||
490: ' from '||l_apps_schema||'.fnd_application'||l_suffix||
491: ' where application_short_name=fnd_global.application_short_name;'||
492: ' '||
493: ' '||l_apps_schema||'.fnd_global.apps_initialize'||l_suffix||'('||
494: ' l_user_id, l_responsibility_id, l_application_id);'||
495: ' '||p_sql||
496: ' end;';
497:

Line 834: last_updated_by = fnd_global.user_id,

830: planning_hub_flag = sys_no,
831: last_run_flag = sys_no,
832: archive_flag = sys_no,
833: last_update_date = sysdate,
834: last_updated_by = fnd_global.user_id,
835: last_update_login = fnd_global.login_id,
836: program_id = fnd_global.conc_program_id,
837: program_login_id = fnd_global.conc_login_id,
838: program_application_id = fnd_global.prog_appl_id,

Line 835: last_update_login = fnd_global.login_id,

831: last_run_flag = sys_no,
832: archive_flag = sys_no,
833: last_update_date = sysdate,
834: last_updated_by = fnd_global.user_id,
835: last_update_login = fnd_global.login_id,
836: program_id = fnd_global.conc_program_id,
837: program_login_id = fnd_global.conc_login_id,
838: program_application_id = fnd_global.prog_appl_id,
839: request_id = fnd_global.conc_request_id

Line 836: program_id = fnd_global.conc_program_id,

832: archive_flag = sys_no,
833: last_update_date = sysdate,
834: last_updated_by = fnd_global.user_id,
835: last_update_login = fnd_global.login_id,
836: program_id = fnd_global.conc_program_id,
837: program_login_id = fnd_global.conc_login_id,
838: program_application_id = fnd_global.prog_appl_id,
839: request_id = fnd_global.conc_request_id
840: where plan_run_id = r.plan_run_id;

Line 837: program_login_id = fnd_global.conc_login_id,

833: last_update_date = sysdate,
834: last_updated_by = fnd_global.user_id,
835: last_update_login = fnd_global.login_id,
836: program_id = fnd_global.conc_program_id,
837: program_login_id = fnd_global.conc_login_id,
838: program_application_id = fnd_global.prog_appl_id,
839: request_id = fnd_global.conc_request_id
840: where plan_run_id = r.plan_run_id;
841: commit;

Line 838: program_application_id = fnd_global.prog_appl_id,

834: last_updated_by = fnd_global.user_id,
835: last_update_login = fnd_global.login_id,
836: program_id = fnd_global.conc_program_id,
837: program_login_id = fnd_global.conc_login_id,
838: program_application_id = fnd_global.prog_appl_id,
839: request_id = fnd_global.conc_request_id
840: where plan_run_id = r.plan_run_id;
841: commit;
842:

Line 839: request_id = fnd_global.conc_request_id

835: last_update_login = fnd_global.login_id,
836: program_id = fnd_global.conc_program_id,
837: program_login_id = fnd_global.conc_login_id,
838: program_application_id = fnd_global.prog_appl_id,
839: request_id = fnd_global.conc_request_id
840: where plan_run_id = r.plan_run_id;
841: commit;
842:
843: l_rowcount := l_rowcount + 1;

Line 862: last_updated_by = fnd_global.user_id,

858: if (l_last_plan_run_id > 0) then
859: update msc_plan_runs set
860: last_run_flag = 1,
861: last_update_date = sysdate,
862: last_updated_by = fnd_global.user_id,
863: last_update_login = fnd_global.login_id,
864: program_id = fnd_global.conc_program_id,
865: program_login_id = fnd_global.conc_login_id,
866: program_application_id = fnd_global.prog_appl_id,

Line 863: last_update_login = fnd_global.login_id,

859: update msc_plan_runs set
860: last_run_flag = 1,
861: last_update_date = sysdate,
862: last_updated_by = fnd_global.user_id,
863: last_update_login = fnd_global.login_id,
864: program_id = fnd_global.conc_program_id,
865: program_login_id = fnd_global.conc_login_id,
866: program_application_id = fnd_global.prog_appl_id,
867: request_id = fnd_global.conc_request_id

Line 864: program_id = fnd_global.conc_program_id,

860: last_run_flag = 1,
861: last_update_date = sysdate,
862: last_updated_by = fnd_global.user_id,
863: last_update_login = fnd_global.login_id,
864: program_id = fnd_global.conc_program_id,
865: program_login_id = fnd_global.conc_login_id,
866: program_application_id = fnd_global.prog_appl_id,
867: request_id = fnd_global.conc_request_id
868: where plan_run_id=l_last_plan_run_id;

Line 865: program_login_id = fnd_global.conc_login_id,

861: last_update_date = sysdate,
862: last_updated_by = fnd_global.user_id,
863: last_update_login = fnd_global.login_id,
864: program_id = fnd_global.conc_program_id,
865: program_login_id = fnd_global.conc_login_id,
866: program_application_id = fnd_global.prog_appl_id,
867: request_id = fnd_global.conc_request_id
868: where plan_run_id=l_last_plan_run_id;
869: else

Line 866: program_application_id = fnd_global.prog_appl_id,

862: last_updated_by = fnd_global.user_id,
863: last_update_login = fnd_global.login_id,
864: program_id = fnd_global.conc_program_id,
865: program_login_id = fnd_global.conc_login_id,
866: program_application_id = fnd_global.prog_appl_id,
867: request_id = fnd_global.conc_request_id
868: where plan_run_id=l_last_plan_run_id;
869: else
870: if (l_plan_id > 0) then

Line 867: request_id = fnd_global.conc_request_id

863: last_update_login = fnd_global.login_id,
864: program_id = fnd_global.conc_program_id,
865: program_login_id = fnd_global.conc_login_id,
866: program_application_id = fnd_global.prog_appl_id,
867: request_id = fnd_global.conc_request_id
868: where plan_run_id=l_last_plan_run_id;
869: else
870: if (l_plan_id > 0) then
871: manage_partitions(item_dim_table, l_plan_id,

Line 945: fnd_global.user_id, sysdate,

941: fnd_profile.value('MSC_HUB_CAT_SET_ID_1') category_set_id1,
942: fnd_profile.value('MSC_HUB_CAT_SET_ID_2') category_set_id2,
943: fnd_profile.value('MSC_HUB_CAT_SET_ID_3') category_set_id3,
944: fnd_profile.value('MSC_APCC_PEGGING_CAT_SET') pg_category_set_id,
945: fnd_global.user_id, sysdate,
946: sysdate, fnd_global.user_id, fnd_global.login_id,
947: fnd_global.conc_program_id, fnd_global.conc_login_id,
948: fnd_global.prog_appl_id, fnd_global.conc_request_id
949: from dual;

Line 946: sysdate, fnd_global.user_id, fnd_global.login_id,

942: fnd_profile.value('MSC_HUB_CAT_SET_ID_2') category_set_id2,
943: fnd_profile.value('MSC_HUB_CAT_SET_ID_3') category_set_id3,
944: fnd_profile.value('MSC_APCC_PEGGING_CAT_SET') pg_category_set_id,
945: fnd_global.user_id, sysdate,
946: sysdate, fnd_global.user_id, fnd_global.login_id,
947: fnd_global.conc_program_id, fnd_global.conc_login_id,
948: fnd_global.prog_appl_id, fnd_global.conc_request_id
949: from dual;
950: commit;

Line 947: fnd_global.conc_program_id, fnd_global.conc_login_id,

943: fnd_profile.value('MSC_HUB_CAT_SET_ID_3') category_set_id3,
944: fnd_profile.value('MSC_APCC_PEGGING_CAT_SET') pg_category_set_id,
945: fnd_global.user_id, sysdate,
946: sysdate, fnd_global.user_id, fnd_global.login_id,
947: fnd_global.conc_program_id, fnd_global.conc_login_id,
948: fnd_global.prog_appl_id, fnd_global.conc_request_id
949: from dual;
950: commit;
951:

Line 948: fnd_global.prog_appl_id, fnd_global.conc_request_id

944: fnd_profile.value('MSC_APCC_PEGGING_CAT_SET') pg_category_set_id,
945: fnd_global.user_id, sysdate,
946: sysdate, fnd_global.user_id, fnd_global.login_id,
947: fnd_global.conc_program_id, fnd_global.conc_login_id,
948: fnd_global.prog_appl_id, fnd_global.conc_request_id
949: from dual;
950: commit;
951:
952: for i in 1..l_ods_table_list.count loop

Line 1017: last_updated_by = fnd_global.user_id,

1013: if (p_success = sys_yes) then
1014: update msc_plan_runs set
1015: last_run_flag=sys_no,
1016: last_update_date = sysdate,
1017: last_updated_by = fnd_global.user_id,
1018: last_update_login = fnd_global.login_id
1019: where plan_name = l_plan_name
1020: and plan_run_id < p_plan_run_id
1021: and (p_plan_id<>-1 or sr_instance_id=l_sr_instance_id);

Line 1018: last_update_login = fnd_global.login_id

1014: update msc_plan_runs set
1015: last_run_flag=sys_no,
1016: last_update_date = sysdate,
1017: last_updated_by = fnd_global.user_id,
1018: last_update_login = fnd_global.login_id
1019: where plan_name = l_plan_name
1020: and plan_run_id < p_plan_run_id
1021: and (p_plan_id<>-1 or sr_instance_id=l_sr_instance_id);
1022:

Line 1201: fnd_global.user_id, sysdate, sysdate, fnd_global.user_id, fnd_global.user_id,

1197: l_plan_version, p_scenario_name,
1198: p_pi.plan_start_date, p_pi.plan_cutoff_date,
1199: p_pi.plan_completion_date, p_pi.publisher,
1200: sysdate, null, sys_no, sys_no, 0, p_local_archive_flag, l_transfer_id,
1201: fnd_global.user_id, sysdate, sysdate, fnd_global.user_id, fnd_global.user_id,
1202: fnd_global.conc_program_id, fnd_global.conc_login_id, fnd_global.prog_appl_id, fnd_global.conc_request_id
1203: );
1204: commit;
1205:

Line 1202: fnd_global.conc_program_id, fnd_global.conc_login_id, fnd_global.prog_appl_id, fnd_global.conc_request_id

1198: p_pi.plan_start_date, p_pi.plan_cutoff_date,
1199: p_pi.plan_completion_date, p_pi.publisher,
1200: sysdate, null, sys_no, sys_no, 0, p_local_archive_flag, l_transfer_id,
1201: fnd_global.user_id, sysdate, sysdate, fnd_global.user_id, fnd_global.user_id,
1202: fnd_global.conc_program_id, fnd_global.conc_login_id, fnd_global.prog_appl_id, fnd_global.conc_request_id
1203: );
1204: commit;
1205:
1206: msc_phub_util.log('msc_phub_pkg.create_plan_run('||p_pi.plan_id||', '||l_plan_run_id||

Line 1344: fnd_global.user_id, sysdate,

1340: null uom_code,
1341: null variable_lead_time,
1342: null volume_uom,
1343: null weight_uom,
1344: fnd_global.user_id, sysdate,
1345: sysdate, fnd_global.user_id, fnd_global.login_id,
1346: fnd_global.conc_program_id, fnd_global.conc_login_id,
1347: fnd_global.prog_appl_id, fnd_global.conc_request_id
1348: from

Line 1345: sysdate, fnd_global.user_id, fnd_global.login_id,

1341: null variable_lead_time,
1342: null volume_uom,
1343: null weight_uom,
1344: fnd_global.user_id, sysdate,
1345: sysdate, fnd_global.user_id, fnd_global.login_id,
1346: fnd_global.conc_program_id, fnd_global.conc_login_id,
1347: fnd_global.prog_appl_id, fnd_global.conc_request_id
1348: from
1349: (select distinct sr_instance_id, sr_category_id1 sr_category_id

Line 1346: fnd_global.conc_program_id, fnd_global.conc_login_id,

1342: null volume_uom,
1343: null weight_uom,
1344: fnd_global.user_id, sysdate,
1345: sysdate, fnd_global.user_id, fnd_global.login_id,
1346: fnd_global.conc_program_id, fnd_global.conc_login_id,
1347: fnd_global.prog_appl_id, fnd_global.conc_request_id
1348: from
1349: (select distinct sr_instance_id, sr_category_id1 sr_category_id
1350: from msc_apcc_item_d

Line 1347: fnd_global.prog_appl_id, fnd_global.conc_request_id

1343: null weight_uom,
1344: fnd_global.user_id, sysdate,
1345: sysdate, fnd_global.user_id, fnd_global.login_id,
1346: fnd_global.conc_program_id, fnd_global.conc_login_id,
1347: fnd_global.prog_appl_id, fnd_global.conc_request_id
1348: from
1349: (select distinct sr_instance_id, sr_category_id1 sr_category_id
1350: from msc_apcc_item_d
1351: where plan_id=p_plan_id and sr_category_id1>=0

Line 1433: fnd_global.user_id, sysdate,

1429: null uom_code,
1430: null variable_lead_time,
1431: null volume_uom,
1432: null weight_uom,
1433: fnd_global.user_id, sysdate,
1434: sysdate, fnd_global.user_id, fnd_global.login_id,
1435: fnd_global.conc_program_id, fnd_global.conc_login_id,
1436: fnd_global.prog_appl_id, fnd_global.conc_request_id
1437: from dual;

Line 1434: sysdate, fnd_global.user_id, fnd_global.login_id,

1430: null variable_lead_time,
1431: null volume_uom,
1432: null weight_uom,
1433: fnd_global.user_id, sysdate,
1434: sysdate, fnd_global.user_id, fnd_global.login_id,
1435: fnd_global.conc_program_id, fnd_global.conc_login_id,
1436: fnd_global.prog_appl_id, fnd_global.conc_request_id
1437: from dual;
1438:

Line 1435: fnd_global.conc_program_id, fnd_global.conc_login_id,

1431: null volume_uom,
1432: null weight_uom,
1433: fnd_global.user_id, sysdate,
1434: sysdate, fnd_global.user_id, fnd_global.login_id,
1435: fnd_global.conc_program_id, fnd_global.conc_login_id,
1436: fnd_global.prog_appl_id, fnd_global.conc_request_id
1437: from dual;
1438:
1439: msc_phub_util.log('msc_phub_pkg.build_null_items: insert='||sql%rowcount);

Line 1436: fnd_global.prog_appl_id, fnd_global.conc_request_id

1432: null weight_uom,
1433: fnd_global.user_id, sysdate,
1434: sysdate, fnd_global.user_id, fnd_global.login_id,
1435: fnd_global.conc_program_id, fnd_global.conc_login_id,
1436: fnd_global.prog_appl_id, fnd_global.conc_request_id
1437: from dual;
1438:
1439: msc_phub_util.log('msc_phub_pkg.build_null_items: insert='||sql%rowcount);
1440: commit;

Line 1540: fnd_global.user_id, sysdate,

1536: i.uom_code,
1537: i.variable_lead_time,
1538: i.volume_uom,
1539: i.weight_uom,
1540: fnd_global.user_id, sysdate,
1541: sysdate, fnd_global.user_id, fnd_global.login_id,
1542: fnd_global.conc_program_id, fnd_global.conc_login_id,
1543: fnd_global.prog_appl_id, fnd_global.conc_request_id
1544: from msc_system_items i,

Line 1541: sysdate, fnd_global.user_id, fnd_global.login_id,

1537: i.variable_lead_time,
1538: i.volume_uom,
1539: i.weight_uom,
1540: fnd_global.user_id, sysdate,
1541: sysdate, fnd_global.user_id, fnd_global.login_id,
1542: fnd_global.conc_program_id, fnd_global.conc_login_id,
1543: fnd_global.prog_appl_id, fnd_global.conc_request_id
1544: from msc_system_items i,
1545: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id

Line 1542: fnd_global.conc_program_id, fnd_global.conc_login_id,

1538: i.volume_uom,
1539: i.weight_uom,
1540: fnd_global.user_id, sysdate,
1541: sysdate, fnd_global.user_id, fnd_global.login_id,
1542: fnd_global.conc_program_id, fnd_global.conc_login_id,
1543: fnd_global.prog_appl_id, fnd_global.conc_request_id
1544: from msc_system_items i,
1545: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id
1546: from msc_phub_item_categories_mv

Line 1543: fnd_global.prog_appl_id, fnd_global.conc_request_id

1539: i.weight_uom,
1540: fnd_global.user_id, sysdate,
1541: sysdate, fnd_global.user_id, fnd_global.login_id,
1542: fnd_global.conc_program_id, fnd_global.conc_login_id,
1543: fnd_global.prog_appl_id, fnd_global.conc_request_id
1544: from msc_system_items i,
1545: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id
1546: from msc_phub_item_categories_mv
1547: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_1')) ic1,

Line 1639: ' fnd_global.user_id, sysdate, fnd_global.user_id, sysdate'||

1635: ' created_by, creation_date, last_updated_by, last_update_date'||
1636: ' )'||
1637: ' select distinct'||
1638: ' :p_query_id, '||l_item_columns||', inventory_item_id,'||
1639: ' fnd_global.user_id, sysdate, fnd_global.user_id, sysdate'||
1640: ' from '||l_table;
1641:
1642: if (l_is_plan) then
1643: l_sql := l_sql||' where plan_id='||p_plan_id;

Line 1787: fnd_global.user_id, sysdate,

1783: d.uom_code,
1784: d.variable_lead_time,
1785: d.volume_uom,
1786: d.weight_uom,
1787: fnd_global.user_id, sysdate,
1788: sysdate, fnd_global.user_id, fnd_global.login_id,
1789: fnd_global.conc_program_id, fnd_global.conc_login_id,
1790: fnd_global.prog_appl_id, fnd_global.conc_request_id
1791: from msc_apcc_item_d d,

Line 1788: sysdate, fnd_global.user_id, fnd_global.login_id,

1784: d.variable_lead_time,
1785: d.volume_uom,
1786: d.weight_uom,
1787: fnd_global.user_id, sysdate,
1788: sysdate, fnd_global.user_id, fnd_global.login_id,
1789: fnd_global.conc_program_id, fnd_global.conc_login_id,
1790: fnd_global.prog_appl_id, fnd_global.conc_request_id
1791: from msc_apcc_item_d d,
1792: (select distinct

Line 1789: fnd_global.conc_program_id, fnd_global.conc_login_id,

1785: d.volume_uom,
1786: d.weight_uom,
1787: fnd_global.user_id, sysdate,
1788: sysdate, fnd_global.user_id, fnd_global.login_id,
1789: fnd_global.conc_program_id, fnd_global.conc_login_id,
1790: fnd_global.prog_appl_id, fnd_global.conc_request_id
1791: from msc_apcc_item_d d,
1792: (select distinct
1793: number3 sr_instance_id,

Line 1790: fnd_global.prog_appl_id, fnd_global.conc_request_id

1786: d.weight_uom,
1787: fnd_global.user_id, sysdate,
1788: sysdate, fnd_global.user_id, fnd_global.login_id,
1789: fnd_global.conc_program_id, fnd_global.conc_login_id,
1790: fnd_global.prog_appl_id, fnd_global.conc_request_id
1791: from msc_apcc_item_d d,
1792: (select distinct
1793: number3 sr_instance_id,
1794: number4 organization_id,

Line 1892: fnd_global.user_id,

1888: l_pi.plan_start_date + v_counter - 1/86400,
1889: 1, --days_in_bkt
1890: 1, --bucket_type
1891: sysdate,
1892: fnd_global.user_id,
1893: sysdate,
1894: fnd_global.user_id
1895: );
1896: end loop;

Line 1894: fnd_global.user_id

1890: 1, --bucket_type
1891: sysdate,
1892: fnd_global.user_id,
1893: sysdate,
1894: fnd_global.user_id
1895: );
1896: end loop;
1897: commit;
1898:

Line 1930: fnd_global.user_id,

1926: 2, --net_purchasing
1927: 2, --plan_safety_stock
1928: 2, --plan_level
1929: sysdate,
1930: fnd_global.user_id,
1931: sysdate,
1932: fnd_global.user_id,
1933: fnd_global.login_id
1934: from msc_instance_orgs mio,

Line 1932: fnd_global.user_id,

1928: 2, --plan_level
1929: sysdate,
1930: fnd_global.user_id,
1931: sysdate,
1932: fnd_global.user_id,
1933: fnd_global.login_id
1934: from msc_instance_orgs mio,
1935: msc_trading_partners mtp
1936: where mio.sr_instance_id = p_sr_instance_id

Line 1933: fnd_global.login_id

1929: sysdate,
1930: fnd_global.user_id,
1931: sysdate,
1932: fnd_global.user_id,
1933: fnd_global.login_id
1934: from msc_instance_orgs mio,
1935: msc_trading_partners mtp
1936: where mio.sr_instance_id = p_sr_instance_id
1937: and mio.sr_instance_id = mtp.sr_instance_id

Line 1976: last_updated_by = fnd_global.user_id,

1972: to_char(plan_completion_date, ' MM/DD')||
1973: '('||plan_run_version||')'||
1974: (case when scenario_name is not null then ' ['||scenario_name||']' end),
1975: last_update_date = sysdate,
1976: last_updated_by = fnd_global.user_id,
1977: last_update_login = fnd_global.login_id,
1978: program_id = fnd_global.conc_program_id,
1979: program_login_id = fnd_global.conc_login_id,
1980: program_application_id = fnd_global.prog_appl_id,

Line 1977: last_update_login = fnd_global.login_id,

1973: '('||plan_run_version||')'||
1974: (case when scenario_name is not null then ' ['||scenario_name||']' end),
1975: last_update_date = sysdate,
1976: last_updated_by = fnd_global.user_id,
1977: last_update_login = fnd_global.login_id,
1978: program_id = fnd_global.conc_program_id,
1979: program_login_id = fnd_global.conc_login_id,
1980: program_application_id = fnd_global.prog_appl_id,
1981: request_id = fnd_global.conc_request_id

Line 1978: program_id = fnd_global.conc_program_id,

1974: (case when scenario_name is not null then ' ['||scenario_name||']' end),
1975: last_update_date = sysdate,
1976: last_updated_by = fnd_global.user_id,
1977: last_update_login = fnd_global.login_id,
1978: program_id = fnd_global.conc_program_id,
1979: program_login_id = fnd_global.conc_login_id,
1980: program_application_id = fnd_global.prog_appl_id,
1981: request_id = fnd_global.conc_request_id
1982: where plan_run_id = l_plan_run_id;

Line 1979: program_login_id = fnd_global.conc_login_id,

1975: last_update_date = sysdate,
1976: last_updated_by = fnd_global.user_id,
1977: last_update_login = fnd_global.login_id,
1978: program_id = fnd_global.conc_program_id,
1979: program_login_id = fnd_global.conc_login_id,
1980: program_application_id = fnd_global.prog_appl_id,
1981: request_id = fnd_global.conc_request_id
1982: where plan_run_id = l_plan_run_id;
1983: commit;

Line 1980: program_application_id = fnd_global.prog_appl_id,

1976: last_updated_by = fnd_global.user_id,
1977: last_update_login = fnd_global.login_id,
1978: program_id = fnd_global.conc_program_id,
1979: program_login_id = fnd_global.conc_login_id,
1980: program_application_id = fnd_global.prog_appl_id,
1981: request_id = fnd_global.conc_request_id
1982: where plan_run_id = l_plan_run_id;
1983: commit;
1984:

Line 1981: request_id = fnd_global.conc_request_id

1977: last_update_login = fnd_global.login_id,
1978: program_id = fnd_global.conc_program_id,
1979: program_login_id = fnd_global.conc_login_id,
1980: program_application_id = fnd_global.prog_appl_id,
1981: request_id = fnd_global.conc_request_id
1982: where plan_run_id = l_plan_run_id;
1983: commit;
1984:
1985: exception