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 703: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID ;

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

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

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

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

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

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

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

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

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

Line 1818: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;

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

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

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

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

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

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

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

Line 2045: last_updated_by = FND_GLOBAL.USER_ID,

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

Line 2047: last_update_login = FND_GLOBAL.LOGIN_ID

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

Line 2051: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID

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

Line 2058: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID

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

Line 2066: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID

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

Line 2074: last_updated_by = FND_GLOBAL.USER_ID,

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

Line 2076: last_update_login = FND_GLOBAL.LOGIN_ID

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

Line 2104: last_updated_by = FND_GLOBAL.USER_ID,

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

Line 2106: last_update_login = FND_GLOBAL.LOGIN_ID

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

Line 4089: last_updated_by= FND_GLOBAL.USER_ID,

4085: SET config_header_id = p_config_header_id,
4086: config_revision_number = p_config_rev_nbr,
4087: valid_config_yn = 'Y',
4088: last_update_date = SYSDATE,
4089: last_updated_by= FND_GLOBAL.USER_ID,
4090: last_update_login= FND_GLOBAL.LOGIN_ID
4091: WHERE document_type = p_document_type
4092: AND document_id = p_document_id ;
4093:

Line 4090: last_update_login= FND_GLOBAL.LOGIN_ID

4086: config_revision_number = p_config_rev_nbr,
4087: valid_config_yn = 'Y',
4088: last_update_date = SYSDATE,
4089: last_updated_by= FND_GLOBAL.USER_ID,
4090: last_update_login= FND_GLOBAL.LOGIN_ID
4091: WHERE document_type = p_document_type
4092: AND document_id = p_document_id ;
4093:
4094: /*

Line 4318: last_updated_by= FND_GLOBAL.USER_ID,

4314: SET config_header_id = p_config_header_id,
4315: config_revision_number = p_config_rev_nbr,
4316: valid_config_yn = 'Y',
4317: last_update_date = SYSDATE,
4318: last_updated_by= FND_GLOBAL.USER_ID,
4319: last_update_login= FND_GLOBAL.LOGIN_ID
4320: WHERE document_type = p_document_type
4321: AND document_id = p_document_id ;
4322:

Line 4319: last_update_login= FND_GLOBAL.LOGIN_ID

4315: config_revision_number = p_config_rev_nbr,
4316: valid_config_yn = 'Y',
4317: last_update_date = SYSDATE,
4318: last_updated_by= FND_GLOBAL.USER_ID,
4319: last_update_login= FND_GLOBAL.LOGIN_ID
4320: WHERE document_type = p_document_type
4321: AND document_id = p_document_id ;
4322:
4323: /*

Line 5901: last_updated_by = FND_GLOBAL.USER_ID,

5897: -- Update Rule status
5898: UPDATE okc_xprt_rule_hdrs_all
5899: SET status_code = DECODE (p_calling_mode, 'PUBLISH', 'ACTIVE', 'DISABLE', 'INACTIVE', 'SYNC', 'ACTIVE'),
5900: published_flag = 'Y',
5901: last_updated_by = FND_GLOBAL.USER_ID,
5902: last_update_date = SYSDATE,
5903: last_update_login = FND_GLOBAL.LOGIN_ID
5904: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;
5905:

Line 5903: last_update_login = FND_GLOBAL.LOGIN_ID

5899: SET status_code = DECODE (p_calling_mode, 'PUBLISH', 'ACTIVE', 'DISABLE', 'INACTIVE', 'SYNC', 'ACTIVE'),
5900: published_flag = 'Y',
5901: last_updated_by = FND_GLOBAL.USER_ID,
5902: last_update_date = SYSDATE,
5903: last_update_login = FND_GLOBAL.LOGIN_ID
5904: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;
5905:
5906:
5907: -- commit work

Line 5904: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;

5900: published_flag = 'Y',
5901: last_updated_by = FND_GLOBAL.USER_ID,
5902: last_update_date = SYSDATE,
5903: last_update_login = FND_GLOBAL.LOGIN_ID
5904: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;
5905:
5906:
5907: -- commit work
5908: commit work;

Line 5980: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;

5976: -- Rules under Publication
5977: CURSOR csr_publish_rules IS
5978: SELECT rule_id
5979: FROM okc_xprt_rule_hdrs_all
5980: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
5981:
5982: -- Rules attached to template
5983: CURSOR csr_approval_rules IS
5984: -- Local Rules on Template