1: PACKAGE BODY PO_DOCUMENT_CHECKS_GRP AS
2: /* $Header: POXGDCKB.pls 120.13 2010/04/07 15:16:12 ssreekum ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_DOCUMENT_CHECKS_GRP';
5:
1: PACKAGE BODY PO_DOCUMENT_CHECKS_GRP AS
2: /* $Header: POXGDCKB.pls 120.13 2010/04/07 15:16:12 ssreekum ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_DOCUMENT_CHECKS_GRP';
5:
6: g_log_head CONSTANT VARCHAR2(50) := 'po.plsql.'|| g_pkg_name || '.';
7:
8: -- Read the profile option that enables/disables the debug log
506: END IF;
507: END IF;
508:
509: -- Call SUB_CHK_2
510: PO_DOCUMENT_CHECKS_GRP.po_submission_check(p_api_version => p_api_version,
511: p_action_requested => p_action_requested,
512: p_document_type => p_document_type,
513: p_document_subtype => p_document_subtype,
514: p_document_level => g_document_level_HEADER,
597: END IF;
598: END IF;
599:
600: -- Call SUB_CHK_2
601: PO_DOCUMENT_CHECKS_GRP.po_submission_check
602: (
603: p_api_version => p_api_version,
604: p_action_requested => p_action_requested,
605: p_document_type => p_document_type,
691: -- as OUT parameter. Setting OUT parameters will be handled within that
692: -- procedure
693:
694: -- Call SUB_CHK_5
695: PO_DOCUMENT_CHECKS_GRP.po_submission_check
696: (
697: p_api_version => p_api_version,
698: p_action_requested => p_action_requested,
699: p_document_type => p_document_type,
1229:
1230: --Call the overloaded procedure that takes in Table IDs after
1231: -- creating size=1 Tables of IDs 1 with value of the scalar input IDs
1232: l_progress := '010';
1233: PO_DOCUMENT_CHECKS_GRP.po_status_check(
1234: p_api_version => p_api_version,
1235: p_header_id => PO_TBL_NUMBER(p_header_id),
1236: p_release_id => PO_TBL_NUMBER(p_release_id),
1237: p_document_type => PO_TBL_VARCHAR30(p_document_type),
1765: , x_price_updateable OUT NOCOPY VARCHAR2
1766: ) IS
1767:
1768: d_module VARCHAR2(70) :=
1769: 'po.plsql.PO_DOCUMENT_CHECKS_GRP.check_payitem_price_updateable';
1770: d_progress NUMBER;
1771: l_is_price_updateable BOOLEAN;
1772:
1773: BEGIN
1829: x_new_report_id OUT NOCOPY NUMBER -- id for new combined online report
1830: )
1831: IS
1832: d_module VARCHAR2(70) :=
1833: 'po.plsql.PO_DOCUMENT_CHECKS_GRP.merge_online_report_id';
1834: d_progress NUMBER;
1835: l_id1_max_seq NUMBER; -- max sequence number value for the first online report
1836: l_id2_seq_list PO_TBL_NUMBER; -- list for all sequence numbers of report 2
1837:
2149: )
2150: IS
2151:
2152: d_module VARCHAR2(70) :=
2153: 'po.plsql.PO_DOCUMENT_CHECKS_GRP.po_combined_submission_check';
2154: d_progress NUMBER;
2155: l_report_id1_rownum NUMBER; --the number of data rows for report 1
2156: l_report_id2_rownum NUMBER; --the number of data rows for report 2
2157: l_report_id2 NUMBER; --id for report 2
2325:
2326: -- Bug 5560980 END
2327:
2328:
2329: END PO_DOCUMENT_CHECKS_GRP;