DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CANCEL_PVT dependencies on PO_DOCUMENT_ACTION_PVT

Line 347: p_entity_dtl IN OUT NOCOPY po_document_action_pvt.entity_dtl_rec_type_tbl,

343: PROCEDURE init_recreate_demand_flag(
344: p_api_version IN NUMBER,
345: p_init_msg_list IN VARCHAR2,
346: p_cancel_reqs_flag IN OUT NOCOPY VARCHAR2,
347: p_entity_dtl IN OUT NOCOPY po_document_action_pvt.entity_dtl_rec_type_tbl,
348: x_return_status OUT NOCOPY VARCHAR2,
349: x_msg_data OUT NOCOPY VARCHAR2)
350: IS
351:

Line 536: entity_dtl_tbl IN po_document_action_pvt.entity_dtl_rec_type_tbl,

532:
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:

Line 3290: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,

3286: LAST_UPDATE_DATE = SYSDATE ,
3287: LAST_UPDATED_BY = p_user_id ,
3288: LAST_UPDATE_LOGIN = p_login_id ,
3289: PORL.REQS_IN_POOL_FLAG = DECODE(l_auth_status,
3290: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,
3291: 'Y',
3292: 'N')
3293:
3294: WHERE PORL.requisition_line_id = p_req_line_id;

Line 3331: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,

3327: LAST_UPDATE_DATE = SYSDATE ,
3328: LAST_UPDATED_BY = p_user_id ,
3329: LAST_UPDATE_LOGIN = p_login_id ,
3330: PORL.REQS_IN_POOL_FLAG = DECODE(l_auth_status,
3331: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,
3332: 'Y',
3333: 'N')
3334:
3335: WHERE PORL.requisition_line_id = p_req_line_id;

Line 5087: -- so calling PO_DOCUMENT_ACTION_PVT.do_approve

5083: --Name: approve_entity
5084: --Function:
5085: -- Approves the entity ebing canceled
5086: -- If the Document Header is Canceled, The entire docuemnt is approved,
5087: -- so calling PO_DOCUMENT_ACTION_PVT.do_approve
5088: -- If the Document Line is cancled, then just the line is approved i.e all its
5089: -- shipments are updated to be Approved.
5090: -- If the Document Shipment is cancled, then just the Shipment is approved
5091:

Line 5182: p_new_status => PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,

5178: PO_DOCUMENT_ACTION_UTIL.update_doc_auth_status(
5179: p_document_id => p_entity_id,
5180: p_document_type => p_document_type,
5181: p_document_subtype => p_doc_subtype,
5182: p_new_status => PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,
5183: p_user_id => l_user_id,
5184: p_login_id => l_login_id,
5185: x_return_status => x_return_status
5186: );

Line 5390: l_auth_status := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;

5386: OR(line_location_id = p_entity_id
5387: AND p_entity_level = c_entity_level_SHIPMENT)) ;
5388:
5389: IF l_count> 0 THEN
5390: l_auth_status := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
5391: ELSE
5392: l_auth_status := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
5393: END IF;
5394:

Line 5392: l_auth_status := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;

5388:
5389: IF l_count> 0 THEN
5390: l_auth_status := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
5391: ELSE
5392: l_auth_status := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
5393: END IF;
5394:
5395: ELSE
5396: l_auth_status := l_head_auth_status;

Line 5436: IF l_auth_status <> PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED THEN

5432:
5433: -- Step 2: Set the entity being canceled to Approved Status
5434: --If the entity being canceled is in "Requires Reapproval"/"Rejected" status then
5435: -- Set the entity to approved status.
5436: IF l_auth_status <> PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED THEN
5437: approve_entity(
5438: p_api_version=> 1.0,
5439: p_init_msg_list=>FND_API.G_FALSE,
5440: p_entity_level => p_entity_level,

Line 5617: -- This method wraps PO_DOCUMENT_ACTION_PVT.auto_close_update_state. .

5613: -- For example, if all of a shipment has been received, then the shipment
5614: -- is closed for receiving
5615: -- Closure Points and Tolerance Levels are set in po_line_locations (for
5616: -- tolerances) and in po_system_parameters (for closed codes) respectively.
5617: -- This method wraps PO_DOCUMENT_ACTION_PVT.auto_close_update_state. .
5618: --
5619: --
5620: --Parameters:
5621: --IN:

Line 5704: PO_DOCUMENT_ACTION_PVT.auto_update_close_state(

5700: END IF;
5701:
5702: l_progress := '002' ;
5703:
5704: PO_DOCUMENT_ACTION_PVT.auto_update_close_state(
5705: p_document_id => p_doc_id,
5706: p_document_type => p_document_type,
5707: p_document_subtype => p_doc_subtype,
5708: p_line_id => l_line_id,

Line 5784: p_da_call_rec IN OUT NOCOPY po_document_action_pvt.DOC_ACTION_CALL_TBL_REC_TYPE,

5780: --------------------------------------------------------------------------------
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,

Line 5800: l_entity_rec_tbl po_document_action_pvt.entity_dtl_rec_type_tbl;

5796: d_api_version CONSTANT NUMBER := 1.0;
5797: d_module CONSTANT VARCHAR2(100) := g_module_prefix|| d_api_name;
5798: l_progress VARCHAR2(8) := '000' ;
5799: l_cancel_reason VARCHAR2(240); --Bug 15836292
5800: l_entity_rec_tbl po_document_action_pvt.entity_dtl_rec_type_tbl;
5801: l_doc_id NUMBER;
5802: l_enc_req_flag VARCHAR2(1);
5803: l_is_new_req_line VARCHAR2(1);
5804: l_po_return_code VARCHAR2(25);

Line 6178: p_entity_rec_tbl IN po_document_action_pvt.entity_dtl_rec_type_tbl,

6174: --
6175: --End of Comments
6176: --------------------------------------------------------------------------------
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,

Line 6311: p_da_call_rec IN OUT NOCOPY po_document_action_pvt.DOC_ACTION_CALL_TBL_REC_TYPE,

6307: --
6308: --End of Comments
6309: --------------------------------------------------------------------------------
6310: PROCEDURE cancel_document(
6311: p_da_call_rec IN OUT NOCOPY po_document_action_pvt.DOC_ACTION_CALL_TBL_REC_TYPE,
6312: p_api_version IN NUMBER,
6313: p_init_msg_list IN VARCHAR2,
6314: x_return_status OUT NOCOPY VARCHAR2,
6315: x_msg_data OUT NOCOPY VARCHAR2,