DBA Data[Home] [Help]

APPS.PON_CLM_CLO_UTIL_PKG dependencies on PO_TBL_NUMBER

Line 1525: x_option_num OUT NOCOPY PO_TBL_NUMBER,

1521:
1522: END;
1523:
1524: PROCEDURE POPULATE_CROSSLINK_MAP(p_auction_header_id IN NUMBER,
1525: x_option_num OUT NOCOPY PO_TBL_NUMBER,
1526: x_base_num OUT NOCOPY PO_TBL_NUMBER) IS
1527: Cursor CrossLinkedOptions is
1528: select DISTINCT aip1.group_line_id option_number, aip2.group_line_id base_number
1529: from pon_auction_item_prices_all aip1,

Line 1526: x_base_num OUT NOCOPY PO_TBL_NUMBER) IS

1522: END;
1523:
1524: PROCEDURE POPULATE_CROSSLINK_MAP(p_auction_header_id IN NUMBER,
1525: x_option_num OUT NOCOPY PO_TBL_NUMBER,
1526: x_base_num OUT NOCOPY PO_TBL_NUMBER) IS
1527: Cursor CrossLinkedOptions is
1528: select DISTINCT aip1.group_line_id option_number, aip2.group_line_id base_number
1529: from pon_auction_item_prices_all aip1,
1530: pon_auction_item_prices_all aip2

Line 1897: p_src_line_numbers IN PO_TBL_NUMBER,

1893: END SEND_LINE_DELETED_NOTIF;
1894:
1895:
1896: PROCEDURE copy_lines(p_auction_header_id IN NUMBER,
1897: p_src_line_numbers IN PO_TBL_NUMBER,
1898: p_user_pref IN copy_user_preferences,
1899: x_max_line_number OUT NOCOPY NUMBER,
1900: x_result OUT NOCOPY VARCHAR2,
1901: x_error_code OUT NOCOPY VARCHAR2,

Line 1905: l_copied_line_numbers PO_TBL_NUMBER := PO_TBL_NUMBER();

1901: x_error_code OUT NOCOPY VARCHAR2,
1902: x_error_message OUT NOCOPY VARCHAR2) AS
1903: TYPE numbers IS TABLE OF NUMBER;
1904: TYPE flags IS TABLE OF VARCHAR2(1);
1905: l_copied_line_numbers PO_TBL_NUMBER := PO_TBL_NUMBER();
1906: l_src_line_number NUMBER;
1907: count_copy NUMBER := 1;
1908: k NUMBER := 0;
1909: