DBA Data[Home] [Help]

APPS.PO_DRAFT_MERGE_PKG dependencies on PO_DOCUMENT_TYPES_ALL

Line 532: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

528: l_return_status VARCHAR2(1);
529: l_msg_count NUMBER;
530: l_msg_data VARCHAR2(2000);
531:
532: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
533: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
534:
535: l_note PO_ACTION_HISTORY.note%TYPE;
536: l_approval_path_id NUMBER;

Line 533: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

529: l_msg_count NUMBER;
530: l_msg_data VARCHAR2(2000);
531:
532: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
533: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
534:
535: l_note PO_ACTION_HISTORY.note%TYPE;
536: l_approval_path_id NUMBER;
537: l_exception_msg VARCHAR2(2000);

Line 1908: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

1904: funcmode IN VARCHAR2,
1905: resultout OUT NOCOPY VARCHAR2)
1906: IS
1907:
1908: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
1909: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
1910: l_draft_id NUMBER;
1911: l_document_id NUMBER;
1912: l_employee_id NUMBER;

Line 1909: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

1905: resultout OUT NOCOPY VARCHAR2)
1906: IS
1907:
1908: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
1909: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
1910: l_draft_id NUMBER;
1911: l_document_id NUMBER;
1912: l_employee_id NUMBER;
1913: l_progress VARCHAR2(1000);