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

Line 10: G_APPL_ID NUMBER := Fnd_Global.Prog_Appl_Id;

6: -- ---------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(30):='IBC_Utilities_Pvt';
8: G_FILE_NAME CONSTANT VARCHAR2(12):='ibcvutlb.pls';
9:
10: G_APPL_ID NUMBER := Fnd_Global.Prog_Appl_Id;
11: G_LOGIN_ID NUMBER := Fnd_Global.Conc_Login_Id;
12: G_PROGRAM_ID NUMBER := Fnd_Global.Conc_Program_Id;
13: G_USER_ID NUMBER := Fnd_Global.User_Id;
14: G_REQUEST_ID NUMBER := Fnd_Global.Conc_Request_Id;

Line 11: G_LOGIN_ID NUMBER := Fnd_Global.Conc_Login_Id;

7: G_PKG_NAME CONSTANT VARCHAR2(30):='IBC_Utilities_Pvt';
8: G_FILE_NAME CONSTANT VARCHAR2(12):='ibcvutlb.pls';
9:
10: G_APPL_ID NUMBER := Fnd_Global.Prog_Appl_Id;
11: G_LOGIN_ID NUMBER := Fnd_Global.Conc_Login_Id;
12: G_PROGRAM_ID NUMBER := Fnd_Global.Conc_Program_Id;
13: G_USER_ID NUMBER := Fnd_Global.User_Id;
14: G_REQUEST_ID NUMBER := Fnd_Global.Conc_Request_Id;
15:

Line 12: G_PROGRAM_ID NUMBER := Fnd_Global.Conc_Program_Id;

8: G_FILE_NAME CONSTANT VARCHAR2(12):='ibcvutlb.pls';
9:
10: G_APPL_ID NUMBER := Fnd_Global.Prog_Appl_Id;
11: G_LOGIN_ID NUMBER := Fnd_Global.Conc_Login_Id;
12: G_PROGRAM_ID NUMBER := Fnd_Global.Conc_Program_Id;
13: G_USER_ID NUMBER := Fnd_Global.User_Id;
14: G_REQUEST_ID NUMBER := Fnd_Global.Conc_Request_Id;
15:
16:

Line 13: G_USER_ID NUMBER := Fnd_Global.User_Id;

9:
10: G_APPL_ID NUMBER := Fnd_Global.Prog_Appl_Id;
11: G_LOGIN_ID NUMBER := Fnd_Global.Conc_Login_Id;
12: G_PROGRAM_ID NUMBER := Fnd_Global.Conc_Program_Id;
13: G_USER_ID NUMBER := Fnd_Global.User_Id;
14: G_REQUEST_ID NUMBER := Fnd_Global.Conc_Request_Id;
15:
16:
17: /****************************************************

Line 14: G_REQUEST_ID NUMBER := Fnd_Global.Conc_Request_Id;

10: G_APPL_ID NUMBER := Fnd_Global.Prog_Appl_Id;
11: G_LOGIN_ID NUMBER := Fnd_Global.Conc_Login_Id;
12: G_PROGRAM_ID NUMBER := Fnd_Global.Conc_Program_Id;
13: G_USER_ID NUMBER := Fnd_Global.User_Id;
14: G_REQUEST_ID NUMBER := Fnd_Global.Conc_Request_Id;
15:
16:
17: /****************************************************
18: -------------FUNCTIONS--------------------------------------------------------------------------

Line 312: l_item_label := Fnd_Global.local_chr(38) || 'amp;label=' || p_item_label;

308: IF (p_item_reference_code IS NOT NULL) THEN
309: l_item_reference_code := p_item_reference_code;
310: END IF;
311: IF (p_item_label IS NOT NULL) THEN
312: l_item_label := Fnd_Global.local_chr(38) || 'amp;label=' || p_item_label;
313: END IF;
314:
315: l_buffer := '<' || p_content_type_code || ' datatype="citem" ' ||
316: G_XML_ID || '="' || p_content_item_id || '" ' ||

Line 383: l_item_label := Fnd_Global.local_chr(38) || 'amp;'|| G_XML_URL_LB ||'=' || p_item_label;

379: IF (p_item_reference_code IS NOT NULL) THEN
380: l_item_reference_code := p_item_reference_code;
381: END IF;
382: IF (p_item_label IS NOT NULL) THEN
383: l_item_label := Fnd_Global.local_chr(38) || 'amp;'|| G_XML_URL_LB ||'=' || p_item_label;
384: END IF;
385:
386: -- // Append Open tag
387: l_buffer := '<' || p_content_type_code || ' datatype="citem" ' ||

Line 399: || Fnd_Global.local_chr(38) || 'amp;cItemVerId=' || p_citem_version_id ||

395: -- // Preview Url
396: IF (p_is_preview = FND_API.g_true) THEN
397: l_buffer := l_buffer ||
398: G_XML_URL || '="' || Ibc_Utilities_Pub.G_PCITEM_SERVLET_URL || 'cItemId=' || p_content_item_id
399: || Fnd_Global.local_chr(38) || 'amp;cItemVerId=' || p_citem_version_id ||
400: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||
401: '">';
402: -- // Runtime Url
403: ELSE

Line 400: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||

396: IF (p_is_preview = FND_API.g_true) THEN
397: l_buffer := l_buffer ||
398: G_XML_URL || '="' || Ibc_Utilities_Pub.G_PCITEM_SERVLET_URL || 'cItemId=' || p_content_item_id
399: || Fnd_Global.local_chr(38) || 'amp;cItemVerId=' || p_citem_version_id ||
400: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||
401: '">';
402: -- // Runtime Url
403: ELSE
404: l_buffer := l_buffer ||

Line 407: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||

403: ELSE
404: l_buffer := l_buffer ||
405: G_XML_URL || '="' || Ibc_Utilities_Pub.G_CITEM_SERVLET_URL || G_XML_URL_CID ||'='|| p_content_item_id ||
406: l_item_label ||
407: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||
408: '">';
409: END IF;
410:
411: -- // Rendition tags

Line 438: -- Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_FID ||'='|| rendition_rec.file_id ||

434: l_buffer := l_buffer || G_XML_DEFAULT_MIME || '="t" ';
435: END IF;
436: l_buffer := l_buffer ||
437: -- G_XML_URL || '="' || Ibc_Utilities_Pub.G_SERVLET_URL || G_XML_URL_CID ||'='|| p_content_item_id ||
438: -- Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_FID ||'='|| rendition_rec.file_id ||
439: -- Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||
440: -- '" />';
441:
442:

Line 439: -- Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||

435: END IF;
436: l_buffer := l_buffer ||
437: -- G_XML_URL || '="' || Ibc_Utilities_Pub.G_SERVLET_URL || G_XML_URL_CID ||'='|| p_content_item_id ||
438: -- Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_FID ||'='|| rendition_rec.file_id ||
439: -- Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||
440: -- '" />';
441:
442:
443: G_XML_URL || '="' || Ibc_Utilities_Pub.G_RENDITION_SERVLET_URL || G_XML_URL_CVERID ||'='|| p_citem_version_id ||

Line 444: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_LANG ||'='|| rendition_rec.language ||

440: -- '" />';
441:
442:
443: G_XML_URL || '="' || Ibc_Utilities_Pub.G_RENDITION_SERVLET_URL || G_XML_URL_CVERID ||'='|| p_citem_version_id ||
444: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_LANG ||'='|| rendition_rec.language ||
445: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_MIME ||'='|| rendition_rec.mime_type ||
446: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||
447: '" />';
448:

Line 445: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_MIME ||'='|| rendition_rec.mime_type ||

441:
442:
443: G_XML_URL || '="' || Ibc_Utilities_Pub.G_RENDITION_SERVLET_URL || G_XML_URL_CVERID ||'='|| p_citem_version_id ||
444: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_LANG ||'='|| rendition_rec.language ||
445: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_MIME ||'='|| rendition_rec.mime_type ||
446: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||
447: '" />';
448:
449:

Line 446: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||

442:
443: G_XML_URL || '="' || Ibc_Utilities_Pub.G_RENDITION_SERVLET_URL || G_XML_URL_CVERID ||'='|| p_citem_version_id ||
444: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_LANG ||'='|| rendition_rec.language ||
445: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_MIME ||'='|| rendition_rec.mime_type ||
446: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||
447: '" />';
448:
449:
450: -- check if the concatenated string is going over the buffer size

Line 468: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_FID ||'='|| p_attachment_file_id ||

464: G_XML_ID || '="' || p_attachment_file_id || '" ' ||
465: G_XML_REF || '="t" ' ||
466: G_XML_FILE || '="' || p_attachment_file_name || '" ' ||
467: G_XML_URL || '="' || Ibc_Utilities_Pub.G_SERVLET_URL || G_XML_URL_CID ||'='|| p_content_item_id ||
468: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_FID ||'='|| p_attachment_file_id ||
469: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||
470: '" />';
471: END IF;
472:

Line 469: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||

465: G_XML_REF || '="t" ' ||
466: G_XML_FILE || '="' || p_attachment_file_name || '" ' ||
467: G_XML_URL || '="' || Ibc_Utilities_Pub.G_SERVLET_URL || G_XML_URL_CID ||'='|| p_content_item_id ||
468: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_FID ||'='|| p_attachment_file_id ||
469: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||
470: '" />';
471: END IF;
472:
473: -- // Name and Description tag

Line 566: l_item_label := Fnd_Global.local_chr(38) || 'amp;label=' || p_item_label;

562: l_buffer VARCHAR2(300);
563: l_item_label VARCHAR2(100) := '';
564: BEGIN
565: IF (p_item_label IS NOT NULL) THEN
566: l_item_label := Fnd_Global.local_chr(38) || 'amp;label=' || p_item_label;
567: END IF;
568:
569: l_buffer := '<' || p_attribute_type_code || ' datatype="component" ' ||
570: G_XML_ID || '="' || p_content_item_id || '" ' ||

Line 574: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||

570: G_XML_ID || '="' || p_content_item_id || '" ' ||
571: G_XML_REF || '="f" ' ||
572: G_XML_URL || '="' || Ibc_Utilities_Pub.G_CITEM_SERVLET_URL || G_XML_URL_CID ||'='|| p_content_item_id ||
573: l_item_label ||
574: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||
575: '">';
576:
577: DBMS_LOB.WRITEAPPEND(p_xml_clob_loc, LENGTH(l_buffer), l_buffer);
578:

Line 595: Fnd_Global.local_chr(38) || 'amp;cItemVerId=' || p_content_item_version_id ||

591: l_buffer := '<' || p_attribute_type_code || ' datatype="component" ' ||
592: G_XML_ID || '="' || p_content_item_id || '" ' ||
593: G_XML_REF || '="f" ' ||
594: G_XML_URL || '="' || Ibc_Utilities_Pub.G_PCITEM_SERVLET_URL || G_XML_URL_CID ||'='|| p_content_item_id ||
595: Fnd_Global.local_chr(38) || 'amp;cItemVerId=' || p_content_item_version_id ||
596: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||
597: '">';
598:
599: DBMS_LOB.WRITEAPPEND(p_xml_clob_loc, LENGTH(l_buffer), l_buffer);

Line 596: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||

592: G_XML_ID || '="' || p_content_item_id || '" ' ||
593: G_XML_REF || '="f" ' ||
594: G_XML_URL || '="' || Ibc_Utilities_Pub.G_PCITEM_SERVLET_URL || G_XML_URL_CID ||'='|| p_content_item_id ||
595: Fnd_Global.local_chr(38) || 'amp;cItemVerId=' || p_content_item_version_id ||
596: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(p_encrypt_flag) ||
597: '">';
598:
599: DBMS_LOB.WRITEAPPEND(p_xml_clob_loc, LENGTH(l_buffer), l_buffer);
600:

Line 627: l_item_label := Fnd_Global.local_chr(38) || 'amp;label=' || p_item_label;

623: AND r.CONTENT_ITEM_ID = c.CONTENT_ITEM_ID
624: ORDER BY r.SORT_ORDER;
625: BEGIN
626: IF (p_item_label IS NOT NULL) THEN
627: l_item_label := Fnd_Global.local_chr(38) || 'amp;label=' || p_item_label;
628: END IF;
629:
630: FOR compound_item_rec IN Get_Compound_Item_Ref LOOP
631: l_buffer := '<' || compound_item_rec.attribute_type_code || ' datatype="component" ' ||

Line 636: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(compound_item_rec.encrypt_flag) ||

632: G_XML_ID || '="' || compound_item_rec.content_item_id || '" ' ||
633: G_XML_REF || '="t" ' ||
634: G_XML_URL || '="' || Ibc_Utilities_Pub.G_CITEM_SERVLET_URL || G_XML_URL_CID ||'='|| compound_item_rec.content_item_id ||
635: l_item_label ||
636: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(compound_item_rec.encrypt_flag) ||
637: '" />';
638:
639: l_total_buffer := l_total_buffer || l_buffer;
640:

Line 693: Fnd_Global.local_chr(38) || 'amp;cItemVerId=' || l_component_version_id ||

689: l_buffer := '<' || compound_item_rec.attribute_type_code || ' datatype="component" ' ||
690: G_XML_ID || '="' || l_component_item_id || '" ' ||
691: G_XML_REF || '="t" ' ||
692: G_XML_URL || '="' || Ibc_Utilities_Pub.G_PCITEM_SERVLET_URL || G_XML_URL_CID ||'='|| l_component_item_id ||
693: Fnd_Global.local_chr(38) || 'amp;cItemVerId=' || l_component_version_id ||
694: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(compound_item_rec.encrypt_flag) ||
695: '" />';
696: l_total_buffer := l_total_buffer || l_buffer;
697:

Line 694: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(compound_item_rec.encrypt_flag) ||

690: G_XML_ID || '="' || l_component_item_id || '" ' ||
691: G_XML_REF || '="t" ' ||
692: G_XML_URL || '="' || Ibc_Utilities_Pub.G_PCITEM_SERVLET_URL || G_XML_URL_CID ||'='|| l_component_item_id ||
693: Fnd_Global.local_chr(38) || 'amp;cItemVerId=' || l_component_version_id ||
694: Fnd_Global.local_chr(38) ||'amp;'|| G_XML_URL_ENC ||'='|| LOWER(compound_item_rec.encrypt_flag) ||
695: '" />';
696: l_total_buffer := l_total_buffer || l_buffer;
697:
698: IF (l_compound_count = 10) THEN

Line 1001: ,p_user_id => Fnd_Global.user_id

997: Ibc_Audit_Logs_Pkg.insert_row(
998: px_audit_log_id => audit_log_id
999: ,p_activity => p_activity
1000: ,p_parent_value => p_parent_value
1001: ,p_user_id => Fnd_Global.user_id
1002: ,p_time_stamp => SYSDATE
1003: ,p_object_type => p_object_type
1004: ,p_object_value1 => p_object_value1
1005: ,p_object_value2 => p_object_value2

Line 1056: ,FND_GLOBAL.user_id

1052: ,object_version_number
1053: )VALUES(
1054: x_lob_file_id
1055: ,p_new_bundle
1056: ,FND_GLOBAL.user_id
1057: ,SYSDATE
1058: ,FND_GLOBAL.user_id
1059: ,SYSDATE
1060: ,FND_GLOBAL.login_id

Line 1058: ,FND_GLOBAL.user_id

1054: x_lob_file_id
1055: ,p_new_bundle
1056: ,FND_GLOBAL.user_id
1057: ,SYSDATE
1058: ,FND_GLOBAL.user_id
1059: ,SYSDATE
1060: ,FND_GLOBAL.login_id
1061: ,1
1062: );

Line 1060: ,FND_GLOBAL.login_id

1056: ,FND_GLOBAL.user_id
1057: ,SYSDATE
1058: ,FND_GLOBAL.user_id
1059: ,SYSDATE
1060: ,FND_GLOBAL.login_id
1061: ,1
1062: );
1063: EXCEPTION
1064: WHEN OTHERS THEN

Line 1182: l_current_user_id := NVL(p_current_user_id, Fnd_Global.user_id);

1178: AND responsibility_id = p_resp_id;
1179:
1180: BEGIN
1181: l_result := 'FALSE';
1182: l_current_user_id := NVL(p_current_user_id, Fnd_Global.user_id);
1183: IF p_user_id IS NOT NULL THEN
1184: IF p_user_id = l_current_user_id THEN
1185: l_result := 'TRUE';
1186: END IF;

Line 1196: IF l_current_user_id = FND_GLOBAL.user_id THEN

1192: l_result := 'TRUE';
1193: END IF;
1194: CLOSE Check_Group;
1195: ELSIF p_resource_type = 'RESPONSIBILITY' THEN
1196: IF l_current_user_id = FND_GLOBAL.user_id THEN
1197: IF p_resource_id = FND_GLOBAL.resp_id THEN
1198: l_result := 'TRUE';
1199: END IF;
1200: ELSE

Line 1197: IF p_resource_id = FND_GLOBAL.resp_id THEN

1193: END IF;
1194: CLOSE Check_Group;
1195: ELSIF p_resource_type = 'RESPONSIBILITY' THEN
1196: IF l_current_user_id = FND_GLOBAL.user_id THEN
1197: IF p_resource_id = FND_GLOBAL.resp_id THEN
1198: l_result := 'TRUE';
1199: END IF;
1200: ELSE
1201: OPEN Check_Responsibility(l_current_user_id, p_resource_id);

Line 1691: l_string := REPLACE( p_string, '&', Fnd_Global.local_chr(38) ||'amp;');

1687: l_string := p_string;
1688: l_pos := INSTR(l_string, '&');
1689:
1690: IF l_pos <> 0 THEN
1691: l_string := REPLACE( p_string, '&', Fnd_Global.local_chr(38) ||'amp;');
1692: END IF;
1693:
1694: RETURN l_string;
1695: