APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on FND_GLOBAL

Line 33: NL VARCHAR2(1) := fnd_global.newline;

29: * | |
30: * +=======================================================================+
31: */
32:
33: NL VARCHAR2(1) := fnd_global.newline;
34: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PO_REQCHANGEREQUESTNOTIF_PVT';
35: G_FILE_NAME CONSTANT VARCHAR2(30) := 'POXVRCNB.pls';
36:
37: -- Read the profile option that enables/disables the debug log

Line 294: NL VARCHAR2(1) := fnd_global.newline;

290: l_document_2 VARCHAR2(32000) := '';
291: l_document_3 VARCHAR2(32000) := '';
292:
293:
294: NL VARCHAR2(1) := fnd_global.newline;
295:
296: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
297:
298:

Line 469: NL VARCHAR2(1) := fnd_global.newline;

465: l_document_2 VARCHAR2(32000) := '';
466: l_document_3 VARCHAR2(32000) := '';
467:
468:
469: NL VARCHAR2(1) := fnd_global.newline;
470:
471: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
472:
473: cursor l_get_wf_keys_csr is

Line 625: NL VARCHAR2(1) := fnd_global.newline;

621: l_req_line_msg VARCHAR2(2000) := '';
622:
623: l_currency_code fnd_currencies.currency_code%TYPE;
624:
625: NL VARCHAR2(1) := fnd_global.newline;
626:
627: i number := 0;
628:
629: l_group_id number := 0;

Line 1137: NL VARCHAR2(1) := fnd_global.newline;

1133: l_req_line_msg VARCHAR2(2000) := '';
1134:
1135: l_currency_code fnd_currencies.currency_code%TYPE;
1136:
1137: NL VARCHAR2(1) := fnd_global.newline;
1138:
1139: i number := 0;
1140:
1141: l_group_id number := 0;

Line 1645: NL VARCHAR2(1) := fnd_global.newline;

1641:
1642: l_first_seq number;
1643: MAX_SEQNO number := 0;
1644:
1645: NL VARCHAR2(1) := fnd_global.newline;
1646:
1647: CURSOR history_csr(v_document_id NUMBER,
1648: v_object_type VARCHAR2) IS
1649:

Line 1836: NL VARCHAR2(1) := fnd_global.newline;

1832: approverList ame_util.approversTable;
1833: upperLimit integer;
1834: fullName varchar2(240);
1835:
1836: NL VARCHAR2(1) := fnd_global.newline;
1837:
1838: CURSOR pending_csr(v_document_id NUMBER, v_object_type VARCHAR2) IS
1839:
1840: SELECT pal.SEQUENCE_NUM,per.FULL_NAME,null,null,null,null

Line 1936: NL VARCHAR2(1) := fnd_global.newline;

1932: l_call_from in varchar2) return varchar2 is
1933:
1934: l_document VARCHAR2(32000) := '';
1935:
1936: NL VARCHAR2(1) := fnd_global.newline;
1937:
1938: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
1939:
1940: l_note po_action_history.note%TYPE;

Line 2122: NL VARCHAR2(1) := fnd_global.newline;

2118: function PrintHeading(l_text in varchar2) return varchar2 is
2119:
2120: l_document varchar2(1000) := '';
2121:
2122: NL VARCHAR2(1) := fnd_global.newline;
2123: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
2124:
2125: begin
2126:

Line 2431: fnd_global.APPS_INITIALIZE (l_user_id,

2427: itemkey => itemkey,
2428: aname => 'RESPONSIBILITY_ID');
2429:
2430: /* Set the context for the doc manager */
2431: fnd_global.APPS_INITIALIZE (l_user_id,
2432: l_responsibility_id,
2433: l_application_id);
2434:
2435: l_progress := 'SetDocMgrContext. USER_ID= ' || to_char(l_user_id)

Line 3264: NL VARCHAR2(1) := fnd_global.newline;

3260: l_pb_rate_date date;
3261: l_pb_rate number;
3262:
3263: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
3264: NL VARCHAR2(1) := fnd_global.newline;
3265:
3266: l_has_temp_labor boolean :=false;
3267: l_num_temp_labors number :=0;
3268: l_old_start_date po_line_locations_all.start_date%TYPE;

Line 3820: NL VARCHAR2(1) := fnd_global.newline;

3816: p_document out NOCOPY varchar2) is
3817:
3818: l_document varchar2(4000);
3819: l_req_details_url varchar2(1000);
3820: NL VARCHAR2(1) := fnd_global.newline;
3821:
3822:
3823: begin
3824: l_document := '' || NL;