1: PACKAGE BODY PO_WF_REQ_NOTIFICATION_R11 AS
2: /* $Header: POXWPA8B.pls 120.0 2005/06/01 14:15:15 appldev noship $ */
3:
4: TYPE line_record IS RECORD (
5:
52:
53: l_document_1 VARCHAR2(32000) := '';
54: l_document_2 VARCHAR2(32000) := '';
55:
56: NL1 VARCHAR2(1) := PO_WF_REQ_NOTIFICATION_R11.newline;
57: NL VARCHAR2(1) := '';
58:
59: BEGIN
60:
228:
229: l_document_1 VARCHAR2(32000) := '';
230: l_document_2 VARCHAR2(32000) := '';
231:
232: NL1 VARCHAR2(1) := PO_WF_REQ_NOTIFICATION_R11.newline;
233: NL VARCHAR2(1) := '';
234:
235: BEGIN
236:
410:
411: l_document_1 VARCHAR2(32000) := '';
412: l_document_2 VARCHAR2(32000) := '';
413:
414: NL VARCHAR2(1) := PO_WF_REQ_NOTIFICATION_R11.newline;
415:
416: BEGIN
417:
418: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
591:
592: l_document_1 VARCHAR2(32000) := '';
593: l_document_2 VARCHAR2(32000) := '';
594:
595: NL VARCHAR2(1) := PO_WF_REQ_NOTIFICATION_R11.newline;
596:
597: BEGIN
598:
599: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
768:
769: l_currency_code fnd_currencies.currency_code%TYPE;
770:
771: NL VARCHAR2(1) := '';
772: NL1 VARCHAR2(1) := PO_WF_REQ_NOTIFICATION_R11.newline;
773: i number := 0;
774:
775: CURSOR line_csr(v_document_id NUMBER) IS
776: SELECT rql.line_num,
1035:
1036: l_currency_code fnd_currencies.currency_code%TYPE;
1037:
1038: NL VARCHAR2(1) := '';
1039: NL1 VARCHAR2(1) := PO_WF_REQ_NOTIFICATION_R11.newline;
1040: i number := 0;
1041:
1042:
1043: CURSOR line_csr(v_document_id NUMBER) IS
1287: l_history history_record;
1288: l_history_seq number;
1289:
1290: NL VARCHAR2(1) := '';
1291: NL1 VARCHAR2(1) := PO_WF_REQ_NOTIFICATION_R11.newline;
1292:
1293: CURSOR history_csr(v_document_id NUMBER, v_object_type VARCHAR2) IS
1294:
1295: SELECT poh.SEQUENCE_NUM,
1451: begin
1452: return(fnd_global.Local_Chr(10));
1453: end Newline;
1454:
1455: END PO_WF_REQ_NOTIFICATION_R11;