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

Line 705: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID ;

701: CURSOR csr_templates IS
702: SELECT DECODE(parent_template_id, NULL, template_id, parent_template_id),
703: template_model_id
704: FROM okc_terms_templates_all
705: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID ;
706:
707: -- UIs for the template not attached to Production publication
708: CURSOR csr_template_ui(p_model_id IN NUMBER) IS
709: SELECT ui_def_id

Line 943: l_user_id CONSTANT Number := Fnd_Global.User_Id;

939: x_Msg_Data OUT NOCOPY VARCHAR2
940: ) AS
941:
942: l_Api_Name CONSTANT VARCHAR2(30) := 'Populate_Questions_Order';
943: l_user_id CONSTANT Number := Fnd_Global.User_Id;
944: l_login_id CONSTANT Number := Fnd_Global.Login_Id;
945: l_conc_request_id CONSTANT Number := Fnd_Global.Conc_Request_Id;
946:
947: cursor Template_Cursor is

Line 944: l_login_id CONSTANT Number := Fnd_Global.Login_Id;

940: ) AS
941:
942: l_Api_Name CONSTANT VARCHAR2(30) := 'Populate_Questions_Order';
943: l_user_id CONSTANT Number := Fnd_Global.User_Id;
944: l_login_id CONSTANT Number := Fnd_Global.Login_Id;
945: l_conc_request_id CONSTANT Number := Fnd_Global.Conc_Request_Id;
946:
947: cursor Template_Cursor is
948: select org_id, intent from okc_terms_templates_all where template_id = p_Template_Id;

Line 945: l_conc_request_id CONSTANT Number := Fnd_Global.Conc_Request_Id;

941:
942: l_Api_Name CONSTANT VARCHAR2(30) := 'Populate_Questions_Order';
943: l_user_id CONSTANT Number := Fnd_Global.User_Id;
944: l_login_id CONSTANT Number := Fnd_Global.Login_Id;
945: l_conc_request_id CONSTANT Number := Fnd_Global.Conc_Request_Id;
946:
947: cursor Template_Cursor is
948: select org_id, intent from okc_terms_templates_all where template_id = p_Template_Id;
949:

Line 1814: AND xprt_request_id = DECODE(p_calling_mode,'TEMPLATE_APPROVAL',xprt_request_id, FND_GLOBAL.CONC_REQUEST_ID);

1810: SELECT DECODE(parent_template_id, NULL, template_id, parent_template_id) template_id,
1811: template_model_id
1812: FROM okc_terms_templates_all
1813: WHERE template_id = DECODE(p_template_id,NULL,template_id,p_template_id)
1814: AND xprt_request_id = DECODE(p_calling_mode,'TEMPLATE_APPROVAL',xprt_request_id, FND_GLOBAL.CONC_REQUEST_ID);
1815: */
1816:
1817: CURSOR csr_rules IS
1818: SELECT rule_id

Line 1820: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;

1816:
1817: CURSOR csr_rules IS
1818: SELECT rule_id
1819: FROM okc_xprt_rule_hdrs_all
1820: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
1821:
1822: CURSOR csr_get_publication_id (p_template_model_id NUMBER, p_publication_mode VARCHAR2) IS
1823: SELECT publication_id ,
1824: ui_def_id

Line 1868: ''TEMPLATE_APPROVAL'',xprt_request_id,'||FND_GLOBAL.CONC_REQUEST_ID||')';

1864: l_sql_stmt := 'SELECT template_model_id
1865: FROM okc_terms_templates_all
1866: WHERE template_id = '||p_template_id||'
1867: AND xprt_request_id = DECODE('''||p_calling_mode||''',
1868: ''TEMPLATE_APPROVAL'',xprt_request_id,'||FND_GLOBAL.CONC_REQUEST_ID||')';
1869: ELSE
1870: l_sql_stmt := 'SELECT template_model_id
1871: FROM okc_terms_templates_all
1872: WHERE xprt_request_id = DECODE('''||p_calling_mode||''',

Line 1873: ''TEMPLATE_APPROVAL'',xprt_request_id,'||FND_GLOBAL.CONC_REQUEST_ID||')';

1869: ELSE
1870: l_sql_stmt := 'SELECT template_model_id
1871: FROM okc_terms_templates_all
1872: WHERE xprt_request_id = DECODE('''||p_calling_mode||''',
1873: ''TEMPLATE_APPROVAL'',xprt_request_id,'||FND_GLOBAL.CONC_REQUEST_ID||')';
1874: END IF;
1875: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1876: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1877: G_MODULE||l_api_name,

Line 2038: fnd_file.put_line(FND_FILE.LOG,'xprt_request_id: '||FND_GLOBAL.CONC_REQUEST_ID);

2034: fnd_file.put_line(FND_FILE.LOG,' ');
2035: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
2036: fnd_file.put_line(FND_FILE.LOG,'p_calling_mode: '||p_calling_mode);
2037: fnd_file.put_line(FND_FILE.LOG,'p_template_id: '||p_template_id);
2038: fnd_file.put_line(FND_FILE.LOG,'xprt_request_id: '||FND_GLOBAL.CONC_REQUEST_ID);
2039: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
2040: fnd_file.put_line(FND_FILE.LOG,' ');
2041:
2042: IF (p_calling_mode = 'PUBLISH') THEN

Line 2047: last_updated_by = FND_GLOBAL.USER_ID,

2043: -- Update all the Question order records that have question_rule_status as PENDINGPUB
2044: UPDATE Okc_Xprt_Question_Orders
2045: SET runtime_available_flag = 'Y',
2046: question_rule_status = 'ACTIVE',
2047: last_updated_by = FND_GLOBAL.USER_ID,
2048: last_update_date = SYSDATE,
2049: last_update_login = FND_GLOBAL.LOGIN_ID
2050: WHERE question_rule_status = 'PENDINGPUB'
2051: AND template_id IN ( SELECT template_id

Line 2049: last_update_login = FND_GLOBAL.LOGIN_ID

2045: SET runtime_available_flag = 'Y',
2046: question_rule_status = 'ACTIVE',
2047: last_updated_by = FND_GLOBAL.USER_ID,
2048: last_update_date = SYSDATE,
2049: last_update_login = FND_GLOBAL.LOGIN_ID
2050: WHERE question_rule_status = 'PENDINGPUB'
2051: AND template_id IN ( SELECT template_id
2052: FROM okc_terms_templates_all
2053: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID

Line 2053: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID

2049: last_update_login = FND_GLOBAL.LOGIN_ID
2050: WHERE question_rule_status = 'PENDINGPUB'
2051: AND template_id IN ( SELECT template_id
2052: FROM okc_terms_templates_all
2053: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID
2054: );
2055: -- Delete from okc_xprt_template_rules
2056: DELETE FROM okc_xprt_template_rules
2057: WHERE NVL(deleted_flag,'N') = 'Y'

Line 2060: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID

2056: DELETE FROM okc_xprt_template_rules
2057: WHERE NVL(deleted_flag,'N') = 'Y'
2058: AND template_id IN ( SELECT template_id
2059: FROM okc_terms_templates_all
2060: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID
2061: );
2062:
2063: -- Update published_flag in okc_xprt_template_rules
2064: UPDATE okc_xprt_template_rules

Line 2068: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID

2064: UPDATE okc_xprt_template_rules
2065: SET published_flag = 'Y'
2066: WHERE template_id IN ( SELECT template_id
2067: FROM okc_terms_templates_all
2068: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID
2069: );
2070: END IF; -- p_calling_mode = 'PUBLISH'
2071:
2072: IF p_calling_mode = 'TEMPLATE_APPROVAL' THEN

Line 2076: last_updated_by = FND_GLOBAL.USER_ID,

2072: IF p_calling_mode = 'TEMPLATE_APPROVAL' THEN
2073: -- if template approval then go by template id
2074: UPDATE Okc_Xprt_Question_Orders
2075: SET runtime_available_flag = 'Y',
2076: last_updated_by = FND_GLOBAL.USER_ID,
2077: last_update_date = SYSDATE,
2078: last_update_login = FND_GLOBAL.LOGIN_ID
2079: WHERE template_id= p_template_id
2080: AND question_rule_status = 'ACTIVE';

Line 2078: last_update_login = FND_GLOBAL.LOGIN_ID

2074: UPDATE Okc_Xprt_Question_Orders
2075: SET runtime_available_flag = 'Y',
2076: last_updated_by = FND_GLOBAL.USER_ID,
2077: last_update_date = SYSDATE,
2078: last_update_login = FND_GLOBAL.LOGIN_ID
2079: WHERE template_id= p_template_id
2080: AND question_rule_status = 'ACTIVE';
2081:
2082: -- Delete from okc_xprt_template_rules

Line 2106: last_updated_by = FND_GLOBAL.USER_ID,

2102: UPDATE okc_xprt_rule_hdrs_all
2103: SET status_code = DECODE (p_calling_mode, 'PUBLISH', 'ACTIVE', 'DISABLE', 'INACTIVE', 'SYNC', 'ACTIVE'),
2104: published_flag = 'Y',
2105: line_level_flag = l_line_level_flag, --is_rule_line_level(l_rule_id),
2106: last_updated_by = FND_GLOBAL.USER_ID,
2107: last_update_date = SYSDATE,
2108: last_update_login = FND_GLOBAL.LOGIN_ID
2109: WHERE rule_id = l_rule_id;
2110:

Line 2108: last_update_login = FND_GLOBAL.LOGIN_ID

2104: published_flag = 'Y',
2105: line_level_flag = l_line_level_flag, --is_rule_line_level(l_rule_id),
2106: last_updated_by = FND_GLOBAL.USER_ID,
2107: last_update_date = SYSDATE,
2108: last_update_login = FND_GLOBAL.LOGIN_ID
2109: WHERE rule_id = l_rule_id;
2110:
2111: END LOOP;
2112: CLOSE csr_rules;

Line 4246: last_updated_by= FND_GLOBAL.USER_ID,

4242: SET config_header_id = p_config_header_id,
4243: config_revision_number = p_config_rev_nbr,
4244: valid_config_yn = 'Y',
4245: last_update_date = SYSDATE,
4246: last_updated_by= FND_GLOBAL.USER_ID,
4247: last_update_login= FND_GLOBAL.LOGIN_ID
4248: WHERE document_type = p_document_type
4249: AND document_id = p_document_id ;
4250:

Line 4247: last_update_login= FND_GLOBAL.LOGIN_ID

4243: config_revision_number = p_config_rev_nbr,
4244: valid_config_yn = 'Y',
4245: last_update_date = SYSDATE,
4246: last_updated_by= FND_GLOBAL.USER_ID,
4247: last_update_login= FND_GLOBAL.LOGIN_ID
4248: WHERE document_type = p_document_type
4249: AND document_id = p_document_id ;
4250:
4251: /*

Line 4516: last_updated_by= FND_GLOBAL.USER_ID,

4512: SET config_header_id = p_config_header_id,
4513: config_revision_number = p_config_rev_nbr,
4514: valid_config_yn = 'Y',
4515: last_update_date = SYSDATE,
4516: last_updated_by= FND_GLOBAL.USER_ID,
4517: last_update_login= FND_GLOBAL.LOGIN_ID
4518: WHERE document_type = p_document_type
4519: AND document_id = p_document_id ;
4520:

Line 4517: last_update_login= FND_GLOBAL.LOGIN_ID

4513: config_revision_number = p_config_rev_nbr,
4514: valid_config_yn = 'Y',
4515: last_update_date = SYSDATE,
4516: last_updated_by= FND_GLOBAL.USER_ID,
4517: last_update_login= FND_GLOBAL.LOGIN_ID
4518: WHERE document_type = p_document_type
4519: AND document_id = p_document_id ;
4520:
4521: /*

Line 6099: last_updated_by = FND_GLOBAL.USER_ID,

6095: -- Update Rule status
6096: UPDATE okc_xprt_rule_hdrs_all
6097: SET status_code = DECODE (p_calling_mode, 'PUBLISH', 'ACTIVE', 'DISABLE', 'INACTIVE', 'SYNC', 'ACTIVE'),
6098: published_flag = 'Y',
6099: last_updated_by = FND_GLOBAL.USER_ID,
6100: last_update_date = SYSDATE,
6101: last_update_login = FND_GLOBAL.LOGIN_ID
6102: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;
6103:

Line 6101: last_update_login = FND_GLOBAL.LOGIN_ID

6097: SET status_code = DECODE (p_calling_mode, 'PUBLISH', 'ACTIVE', 'DISABLE', 'INACTIVE', 'SYNC', 'ACTIVE'),
6098: published_flag = 'Y',
6099: last_updated_by = FND_GLOBAL.USER_ID,
6100: last_update_date = SYSDATE,
6101: last_update_login = FND_GLOBAL.LOGIN_ID
6102: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;
6103:
6104:
6105: -- commit work

Line 6102: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;

6098: published_flag = 'Y',
6099: last_updated_by = FND_GLOBAL.USER_ID,
6100: last_update_date = SYSDATE,
6101: last_update_login = FND_GLOBAL.LOGIN_ID
6102: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;
6103:
6104:
6105: -- commit work
6106: commit work;

Line 6178: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;

6174: -- Rules under Publication
6175: CURSOR csr_publish_rules IS
6176: SELECT rule_id
6177: FROM okc_xprt_rule_hdrs_all
6178: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
6179:
6180: -- Rules attached to template
6181: CURSOR csr_approval_rules IS
6182: -- Local Rules on Template