APPS.PO_UDA_AUTOCREATE_PKG dependencies on PO_HEADERS_ALL

Line 743: FROM po_headers_all

739: -- : Set the l_doc_type correctly
740: IF (po_autocreate_params.g_clm_source_document_id IS NOT NULL) THEN
741: SELECT type_lookup_code
742: INTO l_doc_type
743: FROM po_headers_all
744: WHERE po_header_id = po_autocreate_params.g_clm_source_document_id;
745: ELSE
746: l_doc_type := 'BLANKET';
747: END IF;

Line 754: l_src_table_name := 'PO_HEADERS_ALL';

750:
751: IF p_doc_level = 'HEADER' THEN
752: x_pk1_col_name := 'PO_HEADER_ID';
753: x_pk2_col_name := 'DRAFT_ID';
754: l_src_table_name := 'PO_HEADERS_ALL';
755:
756: ELSIF p_doc_level = 'LINE' THEN
757: x_pk1_col_name := 'PO_LINE_ID';
758: x_pk2_col_name := 'DRAFT_ID';

Line 776: l_src_table_name := 'PO_HEADERS_ALL';

772:
773: IF p_doc_level = 'HEADER' THEN
774: x_pk1_col_name := 'PO_HEADER_ID';
775: x_pk2_col_name := 'DRAFT_ID';
776: l_src_table_name := 'PO_HEADERS_ALL';
777: ELSIF p_doc_level = 'LINE' THEN
778: x_pk1_col_name := 'PO_LINE_ID';
779: x_pk2_col_name := 'DRAFT_ID';
780: l_src_table_name := 'PO_LINES_ALL';

Line 892: FROM po_headers_all

888:
889: IF x_pk1_value IS NOT NULL THEN
890: l_progress := '105';
891: SELECT style_id INTO l_doc_style
892: FROM po_headers_all
893: WHERE po_header_id = x_pk1_value;
894: END IF;
895:
896:

Line 954: FROM po_headers_all

950:
951: IF x_pk1_value IS NOT NULL THEN
952: l_progress := '160';
953: SELECT style_id INTO l_doc_style
954: FROM po_headers_all
955: WHERE po_header_id = x_pk1_value;
956: END IF;
957:
958: IF x_pk1_value IS NOT NULL AND p_doc_level='LINE' AND p_intf_line_id IS NOT NULL

Line 1497: -- Not usre whether we need to update po_headers_all with the new template id

1493: p_pk2_col_name => x_pk2_col_name,
1494: p_pk2_value => x_pk2_value
1495: )
1496: THEN
1497: -- Not usre whether we need to update po_headers_all with the new template id
1498: -- In case of add mode/new mode
1499: l_progress := '070';
1500:
1501: PO_UDA_DATA_UTIL.AutoCreate_User_Attrs

Line 2642: FROM po_headers_all poh,

2638: IF p_level = 'HEADER' THEN
2639:
2640: SELECT distinct pudat.attribute_group_id
2641: BULK COLLECT INTO x_attr_group_id_tbl
2642: FROM po_headers_all poh,
2643: po_uda_ag_template_usages pudat,
2644: EGO_ACTION_DISPLAYS_B ead,
2645: EGO_ACTIONS_B ea
2646: WHERE ea.action_id = ead.action_id

Line 2658: FROM po_headers_all poh,

2654: ELSIF p_level = 'LINE' THEN
2655:
2656: SELECT distinct pudat.attribute_group_id
2657: BULK COLLECT INTO x_attr_group_id_tbl
2658: FROM po_headers_all poh,
2659: po_uda_ag_template_usages pudat,
2660: EGO_ACTION_DISPLAYS_B ead,
2661: EGO_ACTIONS_B ea
2662: WHERE ea.action_id = ead.action_id

Line 2677: FROM po_headers_all poh,

2673: ELSIF p_level = 'SHIPMENT' THEN
2674:
2675: SELECT distinct pudat.attribute_group_id
2676: BULK COLLECT INTO x_attr_group_id_tbl
2677: FROM po_headers_all poh,
2678: po_uda_ag_template_usages pudat,
2679: EGO_ACTION_DISPLAYS_B ead,
2680: EGO_ACTIONS_B ea
2681: WHERE ea.action_id = ead.action_id

Line 3209: l_authorization_status po_headers_all.AUTHORIZATION_STATUS%TYPE; /*bug 12415651*/

3205: x_source_doc_level VARCHAR2(10);
3206: x_group_type VARCHAR2(120);
3207: x_group_property VARCHAR2(120);
3208: x_group_property_tbl PO_TBL_VARCHAR30;
3209: l_authorization_status po_headers_all.AUTHORIZATION_STATUS%TYPE; /*bug 12415651*/
3210:
3211:
3212: BEGIN
3213:

Line 3260: FROM po_headers_all

3256: BEGIN
3257:
3258: select authorization_status
3259: INTO l_authorization_status
3260: FROM po_headers_all
3261: WHERE po_header_id = PO_AUTOCREATE_PARAMS.g_po_header_id;
3262:
3263: EXCEPTION
3264: WHEN No_Data_Found THEN

Line 3408: x_src_template_id := get_template_id (p_table_name => 'PO_HEADERS_ALL'

3404: x_pk2_col_name := 'DRAFT_ID';
3405: x_pk1_value := po_autocreate_params.g_po_header_id;
3406: x_pk2_value := -1;
3407:
3408: x_src_template_id := get_template_id (p_table_name => 'PO_HEADERS_ALL'
3409: ,p_pkey1_col_name => 'PO_HEADER_ID'
3410: ,p_pkey1_val => po_autocreate_params.g_po_header_id
3411: ,p_pkey2_col_name => NULL
3412: ,p_pkey2_val => NULL