[Home] [Help]
533: PROCEDURE denormPlannedPOQty(
534: p_api_version IN NUMBER,
535: p_init_msg_list IN VARCHAR2,
536: entity_dtl_tbl IN po_document_action_pvt.entity_dtl_rec_type_tbl,
537: p_key IN po_session_gt.key%TYPE,
538: x_return_status OUT NOCOPY VARCHAR2)
539: IS
540:
541: d_api_version CONSTANT NUMBER := 1.0;
573: RELS.source_shipment_id = POLL.line_location_id )
574: WHERE POLL.shipment_type = 'PLANNED'
575: AND POLL.line_location_id IN
576: (SELECT num1
577: FROM po_session_gt
578: WHERE char3 = c_entity_level_SHIPMENT
579: AND char2 = c_doc_subtype_PLANNED
580: UNION
581: SELECT line_location_id
579: AND char2 = c_doc_subtype_PLANNED
580: UNION
581: SELECT line_location_id
582: FROM po_line_locations,
583: po_session_gt
584: WHERE num1 = po_line_id
585: AND char3 = c_entity_level_LINE
586: AND char2 = c_doc_subtype_PLANNED
587: AND NVL(cancel_flag, 'N') = 'N'
588: AND NVL(closed_code, 'OPEN') <> 'FINALLY CLOSED'
589: UNION
590: SELECT line_location_id
591: FROM po_line_locations,
592: po_session_gt
593: WHERE num1 = po_header_id
594: AND char3 = c_entity_level_HEADER
595: AND char2 = c_doc_subtype_PLANNED
596: AND NVL(cancel_flag, 'N') = 'N'
610: FROM PO_DISTRIBUTIONS RELD
611: WHERE RELD.source_distribution_id = POD.po_distribution_id )
612: WHERE POD.line_location_id IN
613: ( SELECT num1
614: FROM po_session_gt
615: WHERE char3= c_entity_level_SHIPMENT
616: AND char2 = c_doc_subtype_PLANNED
617: AND char5 = 'Y'
618: UNION
617: AND char5 = 'Y'
618: UNION
619: SELECT line_location_id
620: FROM po_line_locations,
621: po_session_gt
622: WHERE num1 = po_line_id
623: AND shipment_type = 'PLANNED'
624: AND char3 = c_entity_level_LINE
625: AND char2 = c_doc_subtype_PLANNED
628: AND NVL(closed_code, 'OPEN') <> 'FINALLY CLOSED'
629: UNION
630: SELECT line_location_id
631: FROM po_line_locations,
632: po_session_gt
633: WHERE num1 = po_header_id
634: AND shipment_type = 'PLANNED'
635: AND char3 = c_entity_level_HEADER
636: AND char2 = c_doc_subtype_PLANNED
5781: PROCEDURE process_cancel_action(
5782: p_api_version IN NUMBER,
5783: p_init_msg_list IN VARCHAR2,
5784: p_da_call_rec IN OUT NOCOPY po_document_action_pvt.DOC_ACTION_CALL_TBL_REC_TYPE,
5785: p_key IN po_session_gt.key%TYPE,
5786: p_user_id IN po_lines.last_updated_by%TYPE,
5787: p_login_id IN po_lines.last_update_login%TYPE,
5788: p_po_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE,
5789: p_req_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE,
6148: --Start of Comments
6149: --Name: insrtEntityRecInSessiongt
6150:
6151: --Function:
6152: -- Inserts the entity record in po session gt
6153: --
6154: -- Column Mapping is as :
6155: -- num1 => entity_id
6156: -- char1 => document_type
6177: PROCEDURE insrtEntityRecInSessiongt(
6178: p_entity_rec_tbl IN po_document_action_pvt.entity_dtl_rec_type_tbl,
6179: p_api_version IN NUMBER,
6180: p_init_msg_list IN VARCHAR2,
6181: x_key OUT NOCOPY po_session_gt.key%TYPE,
6182: x_return_status OUT NOCOPY VARCHAR2,
6183: x_msg_data OUT NOCOPY VARCHAR2)
6184:
6185: IS
6219: FOR i IN 1.. p_entity_rec_tbl.Count
6220: LOOP
6221:
6222:
6223: INSERT INTO po_session_gt(
6224: KEY ,
6225: num1 ,
6226: char1,
6227: char2,
6321: d_api_version CONSTANT NUMBER := 1.0;
6322: d_module CONSTANT VARCHAR2(100) := g_module_prefix|| d_api_name;
6323:
6324: l_progress VARCHAR2(3) := '000' ;
6325: l_key po_session_gt.key%TYPE;
6326: l_user_id po_lines.last_updated_by%TYPE := -1;
6327: l_login_id po_lines.last_update_login%TYPE := -1;
6328: l_po_encumbrance_flag FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE;
6329: l_req_encumbrance_flag FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE;
6354: END IF;
6355:
6356: l_progress := '001';
6357:
6358: -- Insert the entity record into po_session_gt
6359: insrtEntityRecInSessiongt(
6360: p_api_version=> 1.0,
6361: p_init_msg_list=>FND_API.G_FALSE,
6362: p_entity_rec_tbl=>p_da_call_rec.entity_dtl_record_tbl,