APPS.PO_DOC_STYLE_PVT dependencies on PO_DOC_STYLE_HEADERS

Line 105: l_group_style_id PO_DOC_STYLE_HEADERS.style_id%TYPE;

101: WHERE PGT.KEY = p_session_gt_key
102: AND PGT.NUM2 IS NULL;
103:
104: l_style_id_tbl po_tbl_number;
105: l_group_style_id PO_DOC_STYLE_HEADERS.style_id%TYPE;
106:
107: l_source_doc_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE;
108: l_line_type_id PO_REQUISITION_LINES_ALL.line_type_id%TYPE;
109: l_purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE;

Line 111: l_source_doc_style_id PO_DOC_STYLE_HEADERS.style_id%TYPE;

107: l_source_doc_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE;
108: l_line_type_id PO_REQUISITION_LINES_ALL.line_type_id%TYPE;
109: l_purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE;
110: l_destination_type PO_REQUISITION_LINES_ALL.destination_type_code%TYPE;
111: l_source_doc_style_id PO_DOC_STYLE_HEADERS.style_id%TYPE;
112:
113:
114: BEGIN
115:

Line 433: l_doc_style_id PO_DOC_STYLE_HEADERS.style_id%type;

429: l_api_name CONSTANT VARCHAR2(30) := 'style_validate_req_attrs';
430: l_api_version CONSTANT NUMBER := 1.0;
431:
432:
433: l_doc_style_id PO_DOC_STYLE_HEADERS.style_id%type;
434: l_purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE;
435: l_purchase_basis_enabled BOOLEAN;
436: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%TYPE;
437: l_destination_type PO_LOOKUP_CODES.lookup_code%TYPE;

Line 436: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%TYPE;

432:
433: l_doc_style_id PO_DOC_STYLE_HEADERS.style_id%type;
434: l_purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE;
435: l_purchase_basis_enabled BOOLEAN;
436: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%TYPE;
437: l_destination_type PO_LOOKUP_CODES.lookup_code%TYPE;
438:
439: BEGIN
440:

Line 688: po_doc_style_headers pdsh

684:
685: SELECT pdsh.line_type_allowed
686: INTO x_related_line_types
687: FROM po_doc_style_values pdsv,
688: po_doc_style_headers pdsh
689: WHERE pdsh.style_id = p_style_id
690: AND pdsv.style_id = pdsh.style_id
691: AND pdsv.style_attribute_name = 'PURCHASE_BASES'
692: AND pdsv.style_allowed_value = p_purchase_basis

Line 929: l_style_id PO_DOC_STYLE_HEADERS.STYLE_ID%type;

925:
926: FUNCTION get_doc_style_id(p_doc_id IN NUMBER) RETURN VARCHAR2 IS
927:
928:
929: l_style_id PO_DOC_STYLE_HEADERS.STYLE_ID%type;
930: BEGIN
931: --
932: l_style_id := get_doc_style_id(p_doc_id,-1);
933: RETURN l_style_id;

Line 966: l_style_id PO_DOC_STYLE_HEADERS.STYLE_ID%type;

962:
963: d_progress NUMBER;
964: d_module VARCHAR2(60) := 'po.plsql.PO_DOC_STYLE_PVT.get_doc_style_id';
965:
966: l_style_id PO_DOC_STYLE_HEADERS.STYLE_ID%type;
967: BEGIN
968:
969: d_progress := 0;
970: IF (PO_LOG.d_proc) THEN

Line 1145: FROM po_doc_style_headers

1141: d_progress := 10;
1142:
1143: SELECT progress_payment_flag
1144: INTO l_result
1145: FROM po_doc_style_headers
1146: WHERE style_id = p_style_id;
1147:
1148: IF l_result = 'Y' THEN
1149: RETURN TRUE;