31: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
32: x_lines PO_AUTOCREATE_TYPES.lines_rec_type;
33:
34: --
35: PROCEDURE sync_complex_pricing(p_po_line_id_tbl IN PO_TBL_NUMBER,
36: p_style_id IN NUMBER);
37:
38: PROCEDURE sync_uda(p_po_line_id_tbl IN PO_TBL_NUMBER DEFAULT NULL,
39: p_line_location_id_tbl IN PO_TBL_NUMBER DEFAULT NULL,
34: --
35: PROCEDURE sync_complex_pricing(p_po_line_id_tbl IN PO_TBL_NUMBER,
36: p_style_id IN NUMBER);
37:
38: PROCEDURE sync_uda(p_po_line_id_tbl IN PO_TBL_NUMBER DEFAULT NULL,
39: p_line_location_id_tbl IN PO_TBL_NUMBER DEFAULT NULL,
40: p_level IN VARCHAR2,
41: p_style_id IN NUMBER);
42:
35: PROCEDURE sync_complex_pricing(p_po_line_id_tbl IN PO_TBL_NUMBER,
36: p_style_id IN NUMBER);
37:
38: PROCEDURE sync_uda(p_po_line_id_tbl IN PO_TBL_NUMBER DEFAULT NULL,
39: p_line_location_id_tbl IN PO_TBL_NUMBER DEFAULT NULL,
40: p_level IN VARCHAR2,
41: p_style_id IN NUMBER);
42:
43: /* ============================================================================
48: PROCEDURE merge_to_drafts
49: IS
50: l_api_name VARCHAR2(30) := 'merge_to_drafts';
51: l_progress VARCHAR2(3) := '000';
52: po_line_id_tbl PO_TBL_NUMBER;
53: po_line_loc_id_tbl PO_TBL_NUMBER;
54: draft_id_tbl PO_TBL_NUMBER;
55: delete_flag_tbl PO_TBL_VARCHAR1;
56: x_record_already_exist_tbl PO_TBL_VARCHAR1;
49: IS
50: l_api_name VARCHAR2(30) := 'merge_to_drafts';
51: l_progress VARCHAR2(3) := '000';
52: po_line_id_tbl PO_TBL_NUMBER;
53: po_line_loc_id_tbl PO_TBL_NUMBER;
54: draft_id_tbl PO_TBL_NUMBER;
55: delete_flag_tbl PO_TBL_VARCHAR1;
56: x_record_already_exist_tbl PO_TBL_VARCHAR1;
57: po_dist_id_tbl PO_TBL_NUMBER;
50: l_api_name VARCHAR2(30) := 'merge_to_drafts';
51: l_progress VARCHAR2(3) := '000';
52: po_line_id_tbl PO_TBL_NUMBER;
53: po_line_loc_id_tbl PO_TBL_NUMBER;
54: draft_id_tbl PO_TBL_NUMBER;
55: delete_flag_tbl PO_TBL_VARCHAR1;
56: x_record_already_exist_tbl PO_TBL_VARCHAR1;
57: po_dist_id_tbl PO_TBL_NUMBER;
58: l_style_id NUMBER;
53: po_line_loc_id_tbl PO_TBL_NUMBER;
54: draft_id_tbl PO_TBL_NUMBER;
55: delete_flag_tbl PO_TBL_VARCHAR1;
56: x_record_already_exist_tbl PO_TBL_VARCHAR1;
57: po_dist_id_tbl PO_TBL_NUMBER;
58: l_style_id NUMBER;
59: BEGIN
60:
61: IF g_debug_stmt THEN
2659: when a sync_draft_from_txn occurs
2660: ARGS: p_style_id IN Style id of the document.
2661: ============================================================================ */
2662: PROCEDURE sync_complex_pricing(
2663: p_po_line_id_tbl IN PO_TBL_NUMBER,
2664: p_style_id IN NUMBER)
2665: IS
2666: l_api_name VARCHAR2(30) := 'sync_complex_pricing';
2667: l_progress VARCHAR2(3) := '000';
2799: ARGS: p_style_id IN Style id of the document.
2800: p_level IN Entity level.
2801: ============================================================================ */
2802: PROCEDURE sync_uda(
2803: p_po_line_id_tbl IN PO_TBL_NUMBER DEFAULT NULL,
2804: p_line_location_id_tbl IN PO_TBL_NUMBER DEFAULT NULL,
2805: p_level IN VARCHAR2,
2806: p_style_id IN NUMBER)
2807: IS
2800: p_level IN Entity level.
2801: ============================================================================ */
2802: PROCEDURE sync_uda(
2803: p_po_line_id_tbl IN PO_TBL_NUMBER DEFAULT NULL,
2804: p_line_location_id_tbl IN PO_TBL_NUMBER DEFAULT NULL,
2805: p_level IN VARCHAR2,
2806: p_style_id IN NUMBER)
2807: IS
2808: l_api_name VARCHAR2(30) := 'sync_uda';