DBA Data[Home] [Help]

APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on PO_PRICE_DIFF_DRAFT

Line 40: PROCEDURE insert_po_price_diff_draft

36: (
37: p_dists IN PO_PDOI_TYPES.distributions_rec_type
38: );
39:
40: PROCEDURE insert_po_price_diff_draft
41: (
42: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type
43: );
44:

Line 1670: -- insert price differential rows into po_price_diff_draft

1666: END IF;
1667:
1668: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_INSERT);
1669:
1670: -- insert price differential rows into po_price_diff_draft
1671: insert_po_price_diff_draft
1672: (
1673: p_price_diffs => p_price_diffs
1674: );

Line 1671: insert_po_price_diff_draft

1667:
1668: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_INSERT);
1669:
1670: -- insert price differential rows into po_price_diff_draft
1671: insert_po_price_diff_draft
1672: (
1673: p_price_diffs => p_price_diffs
1674: );
1675:

Line 3402: -- po_price_diff_draft

3398: --Start of Comments
3399: --Name: insert_po_price_diffs_draft
3400: --Function:
3401: -- insert new price differential attribute values into
3402: -- po_price_diff_draft
3403: --Parameters:
3404: --IN:
3405: --p_price_diffs
3406: -- record which contains processed line attributes in a batch;

Line 3414: PROCEDURE insert_po_price_diff_draft

3410: --IN OUT:
3411: --OUT:
3412: --End of Comments
3413: ------------------------------------------------------------------------
3414: PROCEDURE insert_po_price_diff_draft
3415: (
3416: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type
3417: ) IS
3418:

Line 3419: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_price_diff_draft';

3415: (
3416: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type
3417: ) IS
3418:
3419: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_price_diff_draft';
3420: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3421: d_position NUMBER;
3422:
3423: -- variables used to print debug message

Line 3449: INSERT INTO po_price_diff_draft

3445: l_valid_intf_diff_id_tbl);
3446: END IF;
3447:
3448: FORALL i IN 1..p_price_diffs.rec_count
3449: INSERT INTO po_price_diff_draft
3450: (
3451: draft_id,
3452: delete_flag,
3453: change_accepted_flag,

Line 3503: END insert_po_price_diff_draft;

3499: p_pkg_name => d_pkg_name,
3500: p_procedure_name => d_api_name || '.' || d_position
3501: );
3502: RAISE;
3503: END insert_po_price_diff_draft;
3504:
3505: -----------------------------------------------------------------------
3506: --Start of Comments
3507: --Name: merge_po_attr_values_draft