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 1508: ,last_updated_by = fnd_global.user_id

1504: SET business_group_id = p_business_group_id
1505: ,effective_start_date = p_effective_date
1506: ,request_id = nvl(p_master_request_id, g_master_request_id)
1507: ,processing_status = 'P' -- Processing
1508: ,last_updated_by = fnd_global.user_id
1509: ,last_update_date = SYSDATE
1510: ,last_update_login = fnd_global.login_id
1511: ,object_version_number = (object_version_number + 1)
1512: WHERE record_type = 'M'

Line 1510: ,last_update_login = fnd_global.login_id

1506: ,request_id = nvl(p_master_request_id, g_master_request_id)
1507: ,processing_status = 'P' -- Processing
1508: ,last_updated_by = fnd_global.user_id
1509: ,last_update_date = SYSDATE
1510: ,last_update_login = fnd_global.login_id
1511: ,object_version_number = (object_version_number + 1)
1512: WHERE record_type = 'M'
1513: -- Bugfix 3671727:ENH1:ENH2 : Added these AND clauses
1514: AND ext_dfn_id = p_ext_dfn_id

Line 1562: ,fnd_global.user_id

1558: ,p_business_group_id
1559: ,p_effective_date
1560: ,nvl(p_master_request_id, g_master_request_id)
1561: ,'P' -- Processing
1562: ,fnd_global.user_id
1563: ,SYSDATE
1564: ,1
1565: );
1566:

Line 1581: ,last_updated_by = fnd_global.user_id

1577:
1578: -- Step 3.2) Updating multiproc data
1579: UPDATE pqp_ext_cross_person_records
1580: SET processing_status = 'U'
1581: ,last_updated_by = fnd_global.user_id
1582: ,last_update_date = SYSDATE
1583: ,last_update_login = fnd_global.login_id
1584: ,object_version_number = (object_version_number + 1)
1585: WHERE record_type = 'X'

Line 1583: ,last_update_login = fnd_global.login_id

1579: UPDATE pqp_ext_cross_person_records
1580: SET processing_status = 'U'
1581: ,last_updated_by = fnd_global.user_id
1582: ,last_update_date = SYSDATE
1583: ,last_update_login = fnd_global.login_id
1584: ,object_version_number = (object_version_number + 1)
1585: WHERE record_type = 'X'
1586: -- Bugfix 3671727:ENH1:ENH2 : Added these AND clauses
1587: AND ext_dfn_id = p_ext_dfn_id

Line 1623: ,last_updated_by = fnd_global.user_id

1619: -- Also, we need to reset the master BG row in multiproc data
1620: -- table to 'E'
1621: UPDATE pqp_ext_cross_person_records
1622: SET processing_status = 'E' -- Error
1623: ,last_updated_by = fnd_global.user_id
1624: ,last_update_date = SYSDATE
1625: ,last_update_login = fnd_global.login_id
1626: ,object_version_number = (object_version_number + 1)
1627: WHERE record_type = 'M'

Line 1625: ,last_update_login = fnd_global.login_id

1621: UPDATE pqp_ext_cross_person_records
1622: SET processing_status = 'E' -- Error
1623: ,last_updated_by = fnd_global.user_id
1624: ,last_update_date = SYSDATE
1625: ,last_update_login = fnd_global.login_id
1626: ,object_version_number = (object_version_number + 1)
1627: WHERE record_type = 'M'
1628: -- Bugfix 3671727:ENH1 : Added these AND clauses
1629: AND ext_dfn_id = p_ext_dfn_id

Line 1712: g_master_request_id := fnd_global.conc_request_id;

1708:
1709: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
1710:
1711: -- Step 1) Get the master request id
1712: g_master_request_id := fnd_global.conc_request_id;
1713:
1714: IF g_debug THEN
1715: debug('Entering :'||l_proc_name, 10);
1716: debug('g_master_request_id :'||to_char(g_master_request_id), 20);

Line 2065: ,last_updated_by = fnd_global.user_id

2061:
2062: -- First reset the status on multiproc data for master bg row
2063: UPDATE pqp_ext_cross_person_records
2064: SET processing_status = 'E' -- Error
2065: ,last_updated_by = fnd_global.user_id
2066: ,last_update_date = SYSDATE
2067: ,last_update_login = fnd_global.login_id
2068: ,object_version_number = (object_version_number + 1)
2069: WHERE record_type = 'M'

Line 2067: ,last_update_login = fnd_global.login_id

2063: UPDATE pqp_ext_cross_person_records
2064: SET processing_status = 'E' -- Error
2065: ,last_updated_by = fnd_global.user_id
2066: ,last_update_date = SYSDATE
2067: ,last_update_login = fnd_global.login_id
2068: ,object_version_number = (object_version_number + 1)
2069: WHERE record_type = 'M'
2070: -- Bugfix 3671727:ENH1:ENH2 : Added these AND clauses
2071: AND ext_dfn_id = p_ext_dfn_id

Line 2148: ,last_updated_by = fnd_global.user_id

2144:
2145: -- First reset the status on multiproc data for master bg row
2146: UPDATE pqp_ext_cross_person_records
2147: SET processing_status = 'E' -- Error
2148: ,last_updated_by = fnd_global.user_id
2149: ,last_update_date = SYSDATE
2150: ,last_update_login = fnd_global.login_id
2151: ,object_version_number = (object_version_number + 1)
2152: WHERE record_type = 'M'

Line 2150: ,last_update_login = fnd_global.login_id

2146: UPDATE pqp_ext_cross_person_records
2147: SET processing_status = 'E' -- Error
2148: ,last_updated_by = fnd_global.user_id
2149: ,last_update_date = SYSDATE
2150: ,last_update_login = fnd_global.login_id
2151: ,object_version_number = (object_version_number + 1)
2152: WHERE record_type = 'M'
2153: -- Bugfix 3671727:ENH1:ENH2 : Added these AND clauses
2154: AND ext_dfn_id = p_ext_dfn_id

Line 2184: ,last_updated_by = fnd_global.user_id

2180: -- Step 8) Reset the processing status in master Bg
2181: -- and multiproc rows
2182: UPDATE pqp_ext_cross_person_records
2183: SET processing_status = 'C' -- Completed
2184: ,last_updated_by = fnd_global.user_id
2185: ,last_update_date = SYSDATE
2186: ,last_update_login = fnd_global.login_id
2187: ,object_version_number = (object_version_number + 1)
2188: WHERE record_type = 'M'

Line 2186: ,last_update_login = fnd_global.login_id

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

Line 2195: ,last_updated_by = fnd_global.user_id

2191: AND lea_number = g_lea_number;
2192:
2193: UPDATE pqp_ext_cross_person_records
2194: SET processing_status = 'U' -- Back to Unprocessed
2195: ,last_updated_by = fnd_global.user_id
2196: ,last_update_date = SYSDATE
2197: ,last_update_login = fnd_global.login_id
2198: ,object_version_number = (object_version_number + 1)
2199: WHERE record_type = 'X'

Line 2197: ,last_update_login = fnd_global.login_id

2193: UPDATE pqp_ext_cross_person_records
2194: SET processing_status = 'U' -- Back to Unprocessed
2195: ,last_updated_by = fnd_global.user_id
2196: ,last_update_date = SYSDATE
2197: ,last_update_login = fnd_global.login_id
2198: ,object_version_number = (object_version_number + 1)
2199: WHERE record_type = 'X'
2200: -- Bugfix 3671727:ENH1:ENH2 : Added these AND clauses
2201: AND ext_dfn_id = p_ext_dfn_id

Line 2245: ,last_updated_by = fnd_global.user_id

2241: END IF;
2242: -- First reset the status on multiproc data for master bg row
2243: UPDATE pqp_ext_cross_person_records
2244: SET processing_status = 'E' -- Error
2245: ,last_updated_by = fnd_global.user_id
2246: ,last_update_date = SYSDATE
2247: ,last_update_login = fnd_global.login_id
2248: ,object_version_number = (object_version_number + 1)
2249: WHERE record_type = 'M'

Line 2247: ,last_update_login = fnd_global.login_id

2243: UPDATE pqp_ext_cross_person_records
2244: SET processing_status = 'E' -- Error
2245: ,last_updated_by = fnd_global.user_id
2246: ,last_update_date = SYSDATE
2247: ,last_update_login = fnd_global.login_id
2248: ,object_version_number = (object_version_number + 1)
2249: WHERE record_type = 'M'
2250: -- Bugfix 3671727:ENH1:ENH2 : Added these AND clauses
2251: AND ext_dfn_id = p_ext_dfn_id