DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_PVT dependencies on PO_TBL_NUMBER

Line 1143: -- p_par_line_tbl po_tbl_number

1139: --Parameters:
1140: --IN:
1141: -- p_mod_draft_id NUMBER ,
1142: -- p_par_draft_id NUMBER,
1143: -- p_par_line_tbl po_tbl_number
1144: --IN OUT:
1145: --OUT:
1146: --Notes:
1147: --Testing:

Line 1152: p_par_draft_id_tbl IN po_tbl_number,

1148: --End of Comments
1149: ------------------------------------------------------------------------
1150: PROCEDURE do_post_processing_for_par
1151: (p_mod_draft_id IN NUMBER ,
1152: p_par_draft_id_tbl IN po_tbl_number,
1153: p_is_header_changed VARCHAR2 ,
1154: p_par_line_tbl IN po_tbl_number DEFAULT NULL ) IS
1155:
1156: d_api_name CONSTANT VARCHAR2(30) := 'do_post_processing_for_par';

Line 1154: p_par_line_tbl IN po_tbl_number DEFAULT NULL ) IS

1150: PROCEDURE do_post_processing_for_par
1151: (p_mod_draft_id IN NUMBER ,
1152: p_par_draft_id_tbl IN po_tbl_number,
1153: p_is_header_changed VARCHAR2 ,
1154: p_par_line_tbl IN po_tbl_number DEFAULT NULL ) IS
1155:
1156: d_api_name CONSTANT VARCHAR2(30) := 'do_post_processing_for_par';
1157: d_module CONSTANT VARCHAR2(100) := g_pkg_name || d_api_name || '.';
1158: l_distribution_id_tbl po_tbl_number := NULL;

Line 1158: l_distribution_id_tbl po_tbl_number := NULL;

1154: p_par_line_tbl IN po_tbl_number DEFAULT NULL ) IS
1155:
1156: d_api_name CONSTANT VARCHAR2(30) := 'do_post_processing_for_par';
1157: d_module CONSTANT VARCHAR2(100) := g_pkg_name || d_api_name || '.';
1158: l_distribution_id_tbl po_tbl_number := NULL;
1159: l_par_distribution_id_tbl po_tbl_number := NULL;
1160:
1161: BEGIN
1162:

Line 1159: l_par_distribution_id_tbl po_tbl_number := NULL;

1155:
1156: d_api_name CONSTANT VARCHAR2(30) := 'do_post_processing_for_par';
1157: d_module CONSTANT VARCHAR2(100) := g_pkg_name || d_api_name || '.';
1158: l_distribution_id_tbl po_tbl_number := NULL;
1159: l_par_distribution_id_tbl po_tbl_number := NULL;
1160:
1161: BEGIN
1162:
1163: IF (PO_LOG.d_proc) THEN

Line 1377: (p_par_draft_id_tbl IN PO_TBL_NUMBER ,

1373: --Testing:
1374: --End of Comments
1375: ------------------------------------------------------------------------
1376: PROCEDURE COPY_PAR_ATTACHMENTS
1377: (p_par_draft_id_tbl IN PO_TBL_NUMBER ,
1378: p_par_line_id_tbl IN PO_TBL_NUMBER,
1379: p_mod_draft_id IN NUMBER ) IS
1380:
1381: --Fetch All PAR related Shipments

Line 1378: p_par_line_id_tbl IN PO_TBL_NUMBER,

1374: --End of Comments
1375: ------------------------------------------------------------------------
1376: PROCEDURE COPY_PAR_ATTACHMENTS
1377: (p_par_draft_id_tbl IN PO_TBL_NUMBER ,
1378: p_par_line_id_tbl IN PO_TBL_NUMBER,
1379: p_mod_draft_id IN NUMBER ) IS
1380:
1381: --Fetch All PAR related Shipments
1382: CURSOR fetch_line_location_ids(p_line_id NUMBER, p_par_draft_id NUMBER , p_change_status VARCHAR2 ) IS