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.

[Home] [Help]

APPS.OKC_CLS_UTIL dependencies on FND_GLOBAL

Line 136: FND_GLOBAL.USER_ID,

132: CLAUSE_TEXT,
133: to_date(EFF_START_DATE,'mm/dd/yyyy'),
134: to_date(EFF_END_DATE,'mm/dd/yyyy'),
135: ROWNUM,
136: FND_GLOBAL.USER_ID,
137: SYSDATE,
138: FND_GLOBAL.USER_ID,
139: SYSDATE,
140: FND_GLOBAL.LOGIN_ID

Line 138: FND_GLOBAL.USER_ID,

134: to_date(EFF_END_DATE,'mm/dd/yyyy'),
135: ROWNUM,
136: FND_GLOBAL.USER_ID,
137: SYSDATE,
138: FND_GLOBAL.USER_ID,
139: SYSDATE,
140: FND_GLOBAL.LOGIN_ID
141:
142: FROM xmltable('//ProcurementDocumentClause' passing xmltype(p_data)

Line 140: FND_GLOBAL.LOGIN_ID

136: FND_GLOBAL.USER_ID,
137: SYSDATE,
138: FND_GLOBAL.USER_ID,
139: SYSDATE,
140: FND_GLOBAL.LOGIN_ID
141:
142: FROM xmltable('//ProcurementDocumentClause' passing xmltype(p_data)
143: COLUMNS
144: "CLAUSE_SEQUENCE" NUMBER PATH '@id',

Line 227: FND_GLOBAL.USER_ID,

223: decode(REVISION_EDITABLE_YN,'true','Y','false','N',null),
224: REVISION_TITLE,
225: Nvl(p_token,''),
226: ROWNUM,
227: FND_GLOBAL.USER_ID,
228: SYSDATE,
229: FND_GLOBAL.USER_ID,
230: SYSDATE,
231: FND_GLOBAL.LOGIN_ID

Line 229: FND_GLOBAL.USER_ID,

225: Nvl(p_token,''),
226: ROWNUM,
227: FND_GLOBAL.USER_ID,
228: SYSDATE,
229: FND_GLOBAL.USER_ID,
230: SYSDATE,
231: FND_GLOBAL.LOGIN_ID
232: FROM xmltable('//Clause' passing xmltype(p_data)
233: COLUMNS

Line 231: FND_GLOBAL.LOGIN_ID

227: FND_GLOBAL.USER_ID,
228: SYSDATE,
229: FND_GLOBAL.USER_ID,
230: SYSDATE,
231: FND_GLOBAL.LOGIN_ID
232: FROM xmltable('//Clause' passing xmltype(p_data)
233: COLUMNS
234: -- "CLAUSE_SEQUENCE" NUMBER PATH '@id',
235: -- "FULLTEXT_YN" VARCHAR2(10) PATH '@fullText',

Line 310: AND (art.ORG_ID = FND_GLOBAL.ORG_ID

306: AND ver.ORIG_SYSTEM_REFERENCE_CODE = 'CLS'
307: AND ver.ORIG_SYSTEM_REFERENCE_ID1 = buf.REVISION_ID
308: AND ver.ARTICLE_STATUS = 'APPROVED'
309:
310: AND (art.ORG_ID = FND_GLOBAL.ORG_ID
311: OR (exists ( SELECT 1
312: FROM okc_article_ADOPTIONS ADP
313: WHERE adp.global_article_version_id = ver.article_version_id
314: AND adp.adoption_type = 'ADOPTED'

Line 315: AND adp.local_org_id = FND_GLOBAL.ORG_ID

311: OR (exists ( SELECT 1
312: FROM okc_article_ADOPTIONS ADP
313: WHERE adp.global_article_version_id = ver.article_version_id
314: AND adp.adoption_type = 'ADOPTED'
315: AND adp.local_org_id = FND_GLOBAL.ORG_ID
316: AND adp.adoption_status IN ( 'APPROVED', 'ON_HOLD')
317: )
318: )
319: );

Line 334: AND (art.ORG_ID = FND_GLOBAL.ORG_ID

330: AND art.article_number = buf.CLAUSE_NUMBER
331: AND art.article_id = ver.article_id
332: AND SYSDATE BETWEEN Nvl(ver.start_date,SYSDATE-1) AND Nvl(ver.end_date, SYSDATE+1)
333: AND ver.ARTICLE_STATUS = 'APPROVED'
334: AND (art.ORG_ID = FND_GLOBAL.ORG_ID
335: OR (exists ( SELECT 1
336: FROM okc_article_ADOPTIONS ADP
337: WHERE adp.global_article_version_id = ver.article_version_id
338: AND adp.adoption_type = 'ADOPTED'

Line 339: AND adp.local_org_id = FND_GLOBAL.ORG_ID

335: OR (exists ( SELECT 1
336: FROM okc_article_ADOPTIONS ADP
337: WHERE adp.global_article_version_id = ver.article_version_id
338: AND adp.adoption_type = 'ADOPTED'
339: AND adp.local_org_id = FND_GLOBAL.ORG_ID
340: AND adp.adoption_status IN ( 'APPROVED', 'ON_HOLD')
341: )
342: )
343: );

Line 493: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

489:
490: -- update the sections in respective OKC_CLS_CLAUSE_BUFFER_T/ORIG_SECTION_ID
491: UPDATE OKC_CLS_CLAUSE_BUFFER_T
492: SET ORIG_SECTION_ID = l_section_id,
493: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
494: LAST_UPDATE_DATE = SYSDATE,
495: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
496: WHERE token = p_token
497: AND SECTION_ID = l_xml_section_id

Line 495: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

491: UPDATE OKC_CLS_CLAUSE_BUFFER_T
492: SET ORIG_SECTION_ID = l_section_id,
493: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
494: LAST_UPDATE_DATE = SYSDATE,
495: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
496: WHERE token = p_token
497: AND SECTION_ID = l_xml_section_id
498: AND SECTION_NAME = l_xml_section_name
499: AND SECTION_TITLE = l_xml_section_title;

Line 554: AND ORG_ID = FND_GLOBAL.ORG_ID;

550: SELECT Count(1)
551: INTO l_cls_clauses_in_ou_count
552: FROM okc_articles_all
553: WHERE ORIG_SYSTEM_REFERENCE_CODE = 'CLS'
554: AND ORG_ID = FND_GLOBAL.ORG_ID;
555:
556: IF l_cls_clauses_in_ou_count <= 0 THEN
557: x_return_status := 'E';
558: x_err_msg := 'Did not find any clauses from CLS in this OU';

Line 572: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

568: UPDATE OKC_CLS_CLAUSE_BUFFER_T buf
569: SET ORIG_ARTICLE_ID = l_art_ver_ids_tbl(i).art_id ,
570: ORIG_ARTICLE_VERSION_ID = l_art_ver_ids_tbl(i).ver_id,
571: CLAUSE_DISPLAY_SEQUENCE = (l_max_seq + (SERIAL_NUMBER * 10)),
572: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
573: LAST_UPDATE_DATE = SYSDATE,
574: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
575: WHERE buffer_seq_id = l_art_ver_ids_tbl(i).seq_id ;
576:

Line 574: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

570: ORIG_ARTICLE_VERSION_ID = l_art_ver_ids_tbl(i).ver_id,
571: CLAUSE_DISPLAY_SEQUENCE = (l_max_seq + (SERIAL_NUMBER * 10)),
572: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
573: LAST_UPDATE_DATE = SYSDATE,
574: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
575: WHERE buffer_seq_id = l_art_ver_ids_tbl(i).seq_id ;
576:
577:
578:

Line 631: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

627: UPDATE OKC_CLS_CLAUSE_BUFFER_T buf
628: SET ORIG_ARTICLE_ID = l_art_ver_ids_tbl(i).art_id ,
629: ORIG_ARTICLE_VERSION_ID = l_art_ver_ids_tbl(i).ver_id,
630: CLAUSE_DISPLAY_SEQUENCE = (l_max_seq + (SERIAL_NUMBER * 10)),
631: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
632: LAST_UPDATE_DATE = SYSDATE,
633: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
634: WHERE buffer_seq_id = l_art_ver_ids_tbl(i).seq_id ;
635:

Line 633: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

629: ORIG_ARTICLE_VERSION_ID = l_art_ver_ids_tbl(i).ver_id,
630: CLAUSE_DISPLAY_SEQUENCE = (l_max_seq + (SERIAL_NUMBER * 10)),
631: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
632: LAST_UPDATE_DATE = SYSDATE,
633: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
634: WHERE buffer_seq_id = l_art_ver_ids_tbl(i).seq_id ;
635:
636: EXCEPTION
637: WHEN Too_Many_Rows THEN

Line 691: fnd_global.user_id,

687: ORIG_ARTICLE_ID)
688: (SELECT okc_k_articles_b_s.NEXTVAL,
689: ORIG_ARTICLE_ID,
690: 1,
691: fnd_global.user_id,
692: SYSDATE,
693: fnd_global.user_id,
694: SYSDATE,
695: FULLTEXT_YN,

Line 693: fnd_global.user_id,

689: ORIG_ARTICLE_ID,
690: 1,
691: fnd_global.user_id,
692: SYSDATE,
693: fnd_global.user_id,
694: SYSDATE,
695: FULLTEXT_YN,
696: fnd_global.login_id,
697: p_doc_type,

Line 696: fnd_global.login_id,

692: SYSDATE,
693: fnd_global.user_id,
694: SYSDATE,
695: FULLTEXT_YN,
696: fnd_global.login_id,
697: p_doc_type,
698: p_doc_id,
699: 'C',
700: REQUIRED_YN,

Line 742: fnd_global.user_id,

738: art_bus_vbles.VARIABLE_TYPE,
739: art_bus_vbles.EXTERNAL_YN,
740: art_bus_vbles.VALUE_SET_ID,
741: 1,
742: fnd_global.user_id,
743: sysdate,
744: fnd_global.user_id,
745: sysdate,
746: fnd_global.login_id

Line 744: fnd_global.user_id,

740: art_bus_vbles.VALUE_SET_ID,
741: 1,
742: fnd_global.user_id,
743: sysdate,
744: fnd_global.user_id,
745: sysdate,
746: fnd_global.login_id
747: FROM okc_k_articles_b art,
748: OKC_ARTICLE_VARIABLES art_vbles,

Line 746: fnd_global.login_id

742: fnd_global.user_id,
743: sysdate,
744: fnd_global.user_id,
745: sysdate,
746: fnd_global.login_id
747: FROM okc_k_articles_b art,
748: OKC_ARTICLE_VARIABLES art_vbles,
749: OKC_BUS_VARIABLES_B art_bus_vbles
750:

Line 887: FND_GLOBAL.USER_ID,

883: p_timestamp,
884: p_request_body,
885: p_auth_type,
886: p_api_key,
887: FND_GLOBAL.USER_ID,
888: SYSDATE,
889: FND_GLOBAL.USER_ID,
890: SYSDATE,
891: FND_GLOBAL.LOGIN_ID

Line 889: FND_GLOBAL.USER_ID,

885: p_auth_type,
886: p_api_key,
887: FND_GLOBAL.USER_ID,
888: SYSDATE,
889: FND_GLOBAL.USER_ID,
890: SYSDATE,
891: FND_GLOBAL.LOGIN_ID
892: );
893: COMMIT;

Line 891: FND_GLOBAL.LOGIN_ID

887: FND_GLOBAL.USER_ID,
888: SYSDATE,
889: FND_GLOBAL.USER_ID,
890: SYSDATE,
891: FND_GLOBAL.LOGIN_ID
892: );
893: COMMIT;
894:
895: x_return_status := 'S';

Line 962: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

958: UPDATE OKC_CLS_REST_CALLS_LOGS
959: SET RESPONSE_STATUS_CODE = p_response_status_code,
960: TRANSACTION_STATUS = l_transaction_status,
961: RESPONSE = p_response,
962: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
963: LAST_UPDATE_DATE = SYSDATE,
964: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
965: WHERE ID = p_req_seq_id;
966:

Line 964: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

960: TRANSACTION_STATUS = l_transaction_status,
961: RESPONSE = p_response,
962: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
963: LAST_UPDATE_DATE = SYSDATE,
964: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
965: WHERE ID = p_req_seq_id;
966:
967: x_return_status := 'S';
968: x_err_msg := 'Success';