DBA Data[Home] [Help]

APPS.PO_CLOSEOUT_PVT dependencies on PO_MULTI_MOD_VAL_RESULTS_TYPE

Line 845: --x_results PO_MULTI_MOD_VAL_RESULTS_TYPE

841: -- p_chk_list_req VARCHAR2
842:
843: --OUT:
844: --x_result_type VARCHAR2
845: --x_results PO_MULTI_MOD_VAL_RESULTS_TYPE
846:
847: --End of Comments
848: --------------------------------------------------------------------------------
849:

Line 854: , x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

850: PROCEDURE validate_manage_closeout (
851: p_doc_id IN NUMBER
852: , p_chk_list_req IN VARCHAR2
853: , x_result_type OUT NOCOPY VARCHAR2
854: , x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
855: ) IS
856: l_progress NUMBER := 0;
857: l_result VARCHAR2(50);
858: l_tasklist_result VARCHAR2(50);

Line 903: X_RESULTS := PO_MULTI_MOD_VAL_RESULTS_TYPE.NEW_INSTANCE();

899:
900: l_progress := 10;
901:
902: IF (X_RESULTS IS NULL) THEN
903: X_RESULTS := PO_MULTI_MOD_VAL_RESULTS_TYPE.NEW_INSTANCE();
904: END IF;
905:
906: SELECT type_lookup_code
907: INTO l_type_lookup_code

Line 1117: l_results PO_MULTI_MOD_VAL_RESULTS_TYPE;

1113: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'check_exceptions';
1114: l_progress NUMBER := 0;
1115: l_doc_id NUMBER;
1116: l_result_type VARCHAR2(20);
1117: l_results PO_MULTI_MOD_VAL_RESULTS_TYPE;
1118: l_fail_count NUMBER := 0;
1119: l_warn_count NUMBER := 0;
1120: l_validation_status VARCHAR2(20);
1121:

Line 1133: l_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.NEW_INSTANCE();

1129: IF (PO_LOG.d_proc) THEN PO_LOG.proc_begin(d_module); END IF;
1130: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_req_id ' || p_req_id);
1131: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_chk_list_req ' || p_chk_list_req);
1132:
1133: l_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.NEW_INSTANCE();
1134: l_progress := 10;
1135:
1136: DELETE
1137: FROM po_multi_mod_val_results

Line 3142: l_results PO_MULTI_MOD_VAL_RESULTS_TYPE;

3138: IS
3139: l_progress NUMBER := 0;
3140: l_document_id NUMBER;
3141: l_closeout_status VARCHAR2(50);
3142: l_results PO_MULTI_MOD_VAL_RESULTS_TYPE;
3143: l_result_type VARCHAR2(50) := 'SUCCESS';
3144: l_msg VARCHAR2(254);
3145: l_message_subject VARCHAR2(254);
3146: l_messages VARCHAR2(32000);

Line 3173: l_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.NEW_INSTANCE();

3169: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_document_id ' || l_document_id);
3170:
3171: l_progress := 10;
3172:
3173: l_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.NEW_INSTANCE();
3174:
3175: PO_CLOSEOUT_PVT.validate_manage_closeout (p_doc_id => l_document_id
3176: , p_chk_list_req => 'N' -- CheckList Error and Open Mod error are mutual exc, so the checklist added error not req for wf val.
3177: , x_result_type => l_result_type

Line 3412: l_results PO_MULTI_MOD_VAL_RESULTS_TYPE;

3408:
3409: l_progress NUMBER := 0;
3410: l_document_id NUMBER;
3411: l_closeout_status VARCHAR2(50);
3412: l_results PO_MULTI_MOD_VAL_RESULTS_TYPE;
3413: l_msg VARCHAR2(30);
3414:
3415: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'Set_Doc_TO_Prev_State';
3416: d_position NUMBER;

Line 3478: l_results PO_MULTI_MOD_VAL_RESULTS_TYPE;

3474:
3475: l_progress NUMBER := 0;
3476: l_document_id NUMBER;
3477: l_is_physical_complete VARCHAR2(1) := 'N';
3478: l_results PO_MULTI_MOD_VAL_RESULTS_TYPE;
3479: l_msg VARCHAR2(30);
3480:
3481: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'IS_STATUS_PHYSICAL_COMPLETE';
3482: d_position NUMBER;