APPS.PO_AUTOCREATE_DOC dependencies on PO_DOC_STYLE_HEADERS

Line 3262: c1_style_id PO_DOC_STYLE_HEADERS.style_id%type;

3258: for update; --
3259: --bug10064616 changed the condition reqs_in_pool_flag = 'Y' to line_location_id is NULL
3260:
3261: --
3262: c1_style_id PO_DOC_STYLE_HEADERS.style_id%type;
3263: c2_style_id PO_DOC_STYLE_HEADERS.style_id%type;
3264: c1_valid_style BOOLEAN;
3265: c2_valid_style BOOLEAN;
3266: x_return_status VARCHAR2(1);

Line 3263: c2_style_id PO_DOC_STYLE_HEADERS.style_id%type;

3259: --bug10064616 changed the condition reqs_in_pool_flag = 'Y' to line_location_id is NULL
3260:
3261: --
3262: c1_style_id PO_DOC_STYLE_HEADERS.style_id%type;
3263: c2_style_id PO_DOC_STYLE_HEADERS.style_id%type;
3264: c1_valid_style BOOLEAN;
3265: c2_valid_style BOOLEAN;
3266: x_return_status VARCHAR2(1);
3267: x_msg_count NUMBER;

Line 6027: l_style_id PO_DOC_STYLE_HEADERS.style_id%TYPE; --

6023: l_return_status varchar2(1) := NULL;
6024: l_msg_count number := NULL;
6025: l_msg_data varchar2(2000) := NULL;
6026:
6027: l_style_id PO_DOC_STYLE_HEADERS.style_id%TYPE; --
6028: /* Define the cursor which picks up records from the temp table.
6029: * We need the 'for update' since we are going to update the
6030: * process_code.
6031: */

Line 8105: FROM po_doc_style_headers

8101: BEGIN
8102:
8103: SELECT clm_flag
8104: INTO l_clm_flag
8105: FROM po_doc_style_headers
8106: WHERE style_id = (SELECT style_id
8107: FROM po_headers_all
8108: WHERE po_header_id = l_po_header_id );
8109: EXCEPTION