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

Line 838: l_master_request_id NUMBER := fnd_global.conc_request_id;

834: l_ext_param_rec csr_get_ext_param%ROWTYPE;
835: l_ext_rslt_info_rec csr_get_ext_rslt_info%ROWTYPE;
836: l_master_ext_rslt_id NUMBER;
837: l_ext_rslt_id NUMBER;
838: l_master_request_id NUMBER := fnd_global.conc_request_id;
839: l_master_prog_appl_id NUMBER := fnd_global.prog_appl_id;
840: l_master_program_id NUMBER := fnd_global.conc_program_id;
841: l_tab_request_ids pqp_gb_tp_ext_process.t_request_ids_type
842: := p_tab_request_ids;

Line 839: l_master_prog_appl_id NUMBER := fnd_global.prog_appl_id;

835: l_ext_rslt_info_rec csr_get_ext_rslt_info%ROWTYPE;
836: l_master_ext_rslt_id NUMBER;
837: l_ext_rslt_id NUMBER;
838: l_master_request_id NUMBER := fnd_global.conc_request_id;
839: l_master_prog_appl_id NUMBER := fnd_global.prog_appl_id;
840: l_master_program_id NUMBER := fnd_global.conc_program_id;
841: l_tab_request_ids pqp_gb_tp_ext_process.t_request_ids_type
842: := p_tab_request_ids;
843: i NUMBER;

Line 840: l_master_program_id NUMBER := fnd_global.conc_program_id;

836: l_master_ext_rslt_id NUMBER;
837: l_ext_rslt_id NUMBER;
838: l_master_request_id NUMBER := fnd_global.conc_request_id;
839: l_master_prog_appl_id NUMBER := fnd_global.prog_appl_id;
840: l_master_program_id NUMBER := fnd_global.conc_program_id;
841: l_tab_request_ids pqp_gb_tp_ext_process.t_request_ids_type
842: := p_tab_request_ids;
843: i NUMBER;
844: l_effective_date DATE;

Line 1498: ,last_updated_by = fnd_global.user_id

1494: SET business_group_id = p_business_group_id
1495: ,effective_start_date = p_effective_date
1496: ,request_id = nvl(p_master_request_id, g_master_request_id)
1497: ,processing_status = 'P' -- Processing
1498: ,last_updated_by = fnd_global.user_id
1499: ,last_update_date = SYSDATE
1500: ,last_update_login = fnd_global.login_id
1501: ,object_version_number = (object_version_number + 1)
1502: WHERE record_type = 'M'

Line 1500: ,last_update_login = fnd_global.login_id

1496: ,request_id = nvl(p_master_request_id, g_master_request_id)
1497: ,processing_status = 'P' -- Processing
1498: ,last_updated_by = fnd_global.user_id
1499: ,last_update_date = SYSDATE
1500: ,last_update_login = fnd_global.login_id
1501: ,object_version_number = (object_version_number + 1)
1502: WHERE record_type = 'M'
1503: -- Bugfix 3671727:ENH1:ENH2 : Added these AND clauses
1504: AND ext_dfn_id = p_ext_dfn_id

Line 1552: ,fnd_global.user_id

1548: ,p_business_group_id
1549: ,p_effective_date
1550: ,nvl(p_master_request_id, g_master_request_id)
1551: ,'P' -- Processing
1552: ,fnd_global.user_id
1553: ,SYSDATE
1554: ,1
1555: );
1556:

Line 1571: ,last_updated_by = fnd_global.user_id

1567:
1568: -- Step 3.2) Updating multiproc data
1569: UPDATE pqp_ext_cross_person_records
1570: SET processing_status = 'U'
1571: ,last_updated_by = fnd_global.user_id
1572: ,last_update_date = SYSDATE
1573: ,last_update_login = fnd_global.login_id
1574: ,object_version_number = (object_version_number + 1)
1575: WHERE record_type = 'X'

Line 1573: ,last_update_login = fnd_global.login_id

1569: UPDATE pqp_ext_cross_person_records
1570: SET processing_status = 'U'
1571: ,last_updated_by = fnd_global.user_id
1572: ,last_update_date = SYSDATE
1573: ,last_update_login = fnd_global.login_id
1574: ,object_version_number = (object_version_number + 1)
1575: WHERE record_type = 'X'
1576: -- Bugfix 3671727:ENH1:ENH2 : Added these AND clauses
1577: AND ext_dfn_id = p_ext_dfn_id

Line 1613: ,last_updated_by = fnd_global.user_id

1609: -- Also, we need to reset the master BG row in multiproc data
1610: -- table to 'E'
1611: UPDATE pqp_ext_cross_person_records
1612: SET processing_status = 'E' -- Error
1613: ,last_updated_by = fnd_global.user_id
1614: ,last_update_date = SYSDATE
1615: ,last_update_login = fnd_global.login_id
1616: ,object_version_number = (object_version_number + 1)
1617: WHERE record_type = 'M'

Line 1615: ,last_update_login = fnd_global.login_id

1611: UPDATE pqp_ext_cross_person_records
1612: SET processing_status = 'E' -- Error
1613: ,last_updated_by = fnd_global.user_id
1614: ,last_update_date = SYSDATE
1615: ,last_update_login = fnd_global.login_id
1616: ,object_version_number = (object_version_number + 1)
1617: WHERE record_type = 'M'
1618: -- Bugfix 3671727:ENH1 : Added these AND clauses
1619: AND ext_dfn_id = p_ext_dfn_id

Line 1702: g_master_request_id := fnd_global.conc_request_id;

1698:
1699: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
1700:
1701: -- Step 1) Get the master request id
1702: g_master_request_id := fnd_global.conc_request_id;
1703:
1704: IF g_debug THEN
1705: debug('Entering :'||l_proc_name, 10);
1706: debug('g_master_request_id :'||to_char(g_master_request_id), 20);

Line 2055: ,last_updated_by = fnd_global.user_id

2051:
2052: -- First reset the status on multiproc data for master bg row
2053: UPDATE pqp_ext_cross_person_records
2054: SET processing_status = 'E' -- Error
2055: ,last_updated_by = fnd_global.user_id
2056: ,last_update_date = SYSDATE
2057: ,last_update_login = fnd_global.login_id
2058: ,object_version_number = (object_version_number + 1)
2059: WHERE record_type = 'M'

Line 2057: ,last_update_login = fnd_global.login_id

2053: UPDATE pqp_ext_cross_person_records
2054: SET processing_status = 'E' -- Error
2055: ,last_updated_by = fnd_global.user_id
2056: ,last_update_date = SYSDATE
2057: ,last_update_login = fnd_global.login_id
2058: ,object_version_number = (object_version_number + 1)
2059: WHERE record_type = 'M'
2060: -- Bugfix 3671727:ENH1:ENH2 : Added these AND clauses
2061: AND ext_dfn_id = p_ext_dfn_id

Line 2138: ,last_updated_by = fnd_global.user_id

2134:
2135: -- First reset the status on multiproc data for master bg row
2136: UPDATE pqp_ext_cross_person_records
2137: SET processing_status = 'E' -- Error
2138: ,last_updated_by = fnd_global.user_id
2139: ,last_update_date = SYSDATE
2140: ,last_update_login = fnd_global.login_id
2141: ,object_version_number = (object_version_number + 1)
2142: WHERE record_type = 'M'

Line 2140: ,last_update_login = fnd_global.login_id

2136: UPDATE pqp_ext_cross_person_records
2137: SET processing_status = 'E' -- Error
2138: ,last_updated_by = fnd_global.user_id
2139: ,last_update_date = SYSDATE
2140: ,last_update_login = fnd_global.login_id
2141: ,object_version_number = (object_version_number + 1)
2142: WHERE record_type = 'M'
2143: -- Bugfix 3671727:ENH1:ENH2 : Added these AND clauses
2144: AND ext_dfn_id = p_ext_dfn_id

Line 2174: ,last_updated_by = fnd_global.user_id

2170: -- Step 8) Reset the processing status in master Bg
2171: -- and multiproc rows
2172: UPDATE pqp_ext_cross_person_records
2173: SET processing_status = 'C' -- Completed
2174: ,last_updated_by = fnd_global.user_id
2175: ,last_update_date = SYSDATE
2176: ,last_update_login = fnd_global.login_id
2177: ,object_version_number = (object_version_number + 1)
2178: WHERE record_type = 'M'

Line 2176: ,last_update_login = fnd_global.login_id

2172: UPDATE pqp_ext_cross_person_records
2173: SET processing_status = 'C' -- Completed
2174: ,last_updated_by = fnd_global.user_id
2175: ,last_update_date = SYSDATE
2176: ,last_update_login = fnd_global.login_id
2177: ,object_version_number = (object_version_number + 1)
2178: WHERE record_type = 'M'
2179: -- Bugfix 3671727:ENH1:ENH2 : Added these AND clauses
2180: AND ext_dfn_id = p_ext_dfn_id

Line 2185: ,last_updated_by = fnd_global.user_id

2181: AND lea_number = g_lea_number;
2182:
2183: UPDATE pqp_ext_cross_person_records
2184: SET processing_status = 'U' -- Back to Unprocessed
2185: ,last_updated_by = fnd_global.user_id
2186: ,last_update_date = SYSDATE
2187: ,last_update_login = fnd_global.login_id
2188: ,object_version_number = (object_version_number + 1)
2189: WHERE record_type = 'X'

Line 2187: ,last_update_login = fnd_global.login_id

2183: UPDATE pqp_ext_cross_person_records
2184: SET processing_status = 'U' -- Back to Unprocessed
2185: ,last_updated_by = fnd_global.user_id
2186: ,last_update_date = SYSDATE
2187: ,last_update_login = fnd_global.login_id
2188: ,object_version_number = (object_version_number + 1)
2189: WHERE record_type = 'X'
2190: -- Bugfix 3671727:ENH1:ENH2 : Added these AND clauses
2191: AND ext_dfn_id = p_ext_dfn_id

Line 2235: ,last_updated_by = fnd_global.user_id

2231: END IF;
2232: -- First reset the status on multiproc data for master bg row
2233: UPDATE pqp_ext_cross_person_records
2234: SET processing_status = 'E' -- Error
2235: ,last_updated_by = fnd_global.user_id
2236: ,last_update_date = SYSDATE
2237: ,last_update_login = fnd_global.login_id
2238: ,object_version_number = (object_version_number + 1)
2239: WHERE record_type = 'M'

Line 2237: ,last_update_login = fnd_global.login_id

2233: UPDATE pqp_ext_cross_person_records
2234: SET processing_status = 'E' -- Error
2235: ,last_updated_by = fnd_global.user_id
2236: ,last_update_date = SYSDATE
2237: ,last_update_login = fnd_global.login_id
2238: ,object_version_number = (object_version_number + 1)
2239: WHERE record_type = 'M'
2240: -- Bugfix 3671727:ENH1:ENH2 : Added these AND clauses
2241: AND ext_dfn_id = p_ext_dfn_id