DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_MAINPROC_PVT dependencies on PO_TBL_NUMBER

Line 35: PROCEDURE sync_complex_pricing(p_po_line_id_tbl IN PO_TBL_NUMBER,

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,

Line 38: PROCEDURE sync_uda(p_po_line_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:

Line 39: p_line_location_id_tbl IN PO_TBL_NUMBER DEFAULT NULL,

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: /* ============================================================================

Line 52: po_line_id_tbl PO_TBL_NUMBER;

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;

Line 53: po_line_loc_id_tbl PO_TBL_NUMBER;

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;

Line 54: draft_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;

Line 57: po_dist_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;
59: BEGIN
60:
61: IF g_debug_stmt THEN

Line 2663: p_po_line_id_tbl IN PO_TBL_NUMBER,

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';

Line 2803: p_po_line_id_tbl IN PO_TBL_NUMBER DEFAULT NULL,

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

Line 2804: p_line_location_id_tbl IN PO_TBL_NUMBER DEFAULT NULL,

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';