DBA Data[Home] [Help]

APPS.PO_WF_REQ_NOTIFICATION_R11 dependencies on PO_WF_REQ_NOTIFICATION_R11

Line 1: PACKAGE BODY PO_WF_REQ_NOTIFICATION_R11 AS

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:

Line 56: NL1 VARCHAR2(1) := PO_WF_REQ_NOTIFICATION_R11.newline;

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:

Line 232: NL1 VARCHAR2(1) := PO_WF_REQ_NOTIFICATION_R11.newline;

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:

Line 414: NL VARCHAR2(1) := PO_WF_REQ_NOTIFICATION_R11.newline;

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);

Line 595: NL VARCHAR2(1) := PO_WF_REQ_NOTIFICATION_R11.newline;

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);

Line 772: NL1 VARCHAR2(1) := PO_WF_REQ_NOTIFICATION_R11.newline;

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,

Line 1039: NL1 VARCHAR2(1) := PO_WF_REQ_NOTIFICATION_R11.newline;

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

Line 1291: NL1 VARCHAR2(1) := PO_WF_REQ_NOTIFICATION_R11.newline;

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,

Line 1455: END PO_WF_REQ_NOTIFICATION_R11;

1451: begin
1452: return(fnd_global.Local_Chr(10));
1453: end Newline;
1454:
1455: END PO_WF_REQ_NOTIFICATION_R11;