eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_LARGE_AUCTION_UTIL_PKG dependencies on PON_BID_HEADERS

Line 17: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,

13: -- COMMENT: Deletes line level attachments for a bid
14: -- ======================================================================
15: PROCEDURE delete_line_attachments
16: (
17: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
18: p_bid_number IN pon_bid_headers.bid_number%TYPE,
19: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
20: p_batch_end IN pon_bid_item_prices.line_number%TYPE
21: ) IS

Line 18: p_bid_number IN pon_bid_headers.bid_number%TYPE,

14: -- ======================================================================
15: PROCEDURE delete_line_attachments
16: (
17: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
18: p_bid_number IN pon_bid_headers.bid_number%TYPE,
19: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
20: p_batch_end IN pon_bid_item_prices.line_number%TYPE
21: ) IS
22:

Line 54: p_bid_number IN pon_bid_headers.bid_number%TYPE,

50: -- COMMENT: Deletes payment level attachments for a bid
51: -- ======================================================================
52: PROCEDURE delete_bid_payment_attachments
53: (
54: p_bid_number IN pon_bid_headers.bid_number%TYPE,
55: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
56: p_batch_end IN pon_bid_item_prices.line_number%TYPE
57: ) IS
58:

Line 120: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,

116: -- COMMENT: Completely deletes a bid from the database
117: -- ======================================================================
118: PROCEDURE delete_bid
119: (
120: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
121: p_bid_number IN pon_bid_headers.bid_number%TYPE
122: ) IS
123: l_max_line_number pon_bid_item_prices.line_number%TYPE;
124: l_batch_start pon_bid_item_prices.line_number%TYPE;

Line 121: p_bid_number IN pon_bid_headers.bid_number%TYPE

117: -- ======================================================================
118: PROCEDURE delete_bid
119: (
120: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
121: p_bid_number IN pon_bid_headers.bid_number%TYPE
122: ) IS
123: l_max_line_number pon_bid_item_prices.line_number%TYPE;
124: l_batch_start pon_bid_item_prices.line_number%TYPE;
125: l_batch_end pon_bid_item_prices.line_number%TYPE;

Line 472: p_bid_number IN pon_bid_headers.bid_number%TYPE

468: -- the bid is pending or completed
469: -- ======================================================================
470: FUNCTION is_bid_request_pending
471: (
472: p_bid_number IN pon_bid_headers.bid_number%TYPE
473: ) RETURN VARCHAR2 IS
474: l_request_id pon_bid_headers.request_id%TYPE;
475: BEGIN
476:

Line 474: l_request_id pon_bid_headers.request_id%TYPE;

470: FUNCTION is_bid_request_pending
471: (
472: p_bid_number IN pon_bid_headers.bid_number%TYPE
473: ) RETURN VARCHAR2 IS
474: l_request_id pon_bid_headers.request_id%TYPE;
475: BEGIN
476:
477: SELECT request_id
478: INTO l_request_id

Line 479: FROM pon_bid_headers

475: BEGIN
476:
477: SELECT request_id
478: INTO l_request_id
479: FROM pon_bid_headers
480: WHERE bid_number = p_bid_number;
481:
482: IF (l_request_id IS null) THEN
483: RETURN 'N';

Line 962: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,

958: -- bid headers.
959: -- ======================================================================
960: PROCEDURE delete_bid_by_header
961: (
962: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
963: p_bid_number IN pon_bid_headers.bid_number%TYPE,
964: P_doc_type IN varchar2,
965: x_msg_count OUT NOCOPY NUMBER,
966: x_return_status OUT NOCOPY VARCHAR2,

Line 963: p_bid_number IN pon_bid_headers.bid_number%TYPE,

959: -- ======================================================================
960: PROCEDURE delete_bid_by_header
961: (
962: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
963: p_bid_number IN pon_bid_headers.bid_number%TYPE,
964: P_doc_type IN varchar2,
965: x_msg_count OUT NOCOPY NUMBER,
966: x_return_status OUT NOCOPY VARCHAR2,
967: x_msg_data OUT NOCOPY VARCHAR2

Line 1014: delete from pon_bid_headers where bid_number = p_bid_number;

1010: p_bid_number => p_bid_number
1011: );
1012:
1013: -- Delete bid header
1014: delete from pon_bid_headers where bid_number = p_bid_number;
1015:
1016: EXCEPTION
1017: WHEN PON_FAIL_CALL_DEL_DOC THEN
1018: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1035: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,

1031:
1032: -- Delete bid header attachment
1033: PROCEDURE delete_bid_header_attachment
1034: (
1035: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
1036: p_bid_number IN pon_bid_headers.bid_number%TYPE
1037:
1038: ) IS
1039: BEGIN

Line 1036: p_bid_number IN pon_bid_headers.bid_number%TYPE

1032: -- Delete bid header attachment
1033: PROCEDURE delete_bid_header_attachment
1034: (
1035: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
1036: p_bid_number IN pon_bid_headers.bid_number%TYPE
1037:
1038: ) IS
1039: BEGIN
1040:

Line 1043: (x_entity_name => 'PON_BID_HEADERS',

1039: BEGIN
1040:
1041: -- Delete bid header attachment
1042: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
1043: (x_entity_name => 'PON_BID_HEADERS',
1044: x_pk1_value => p_auc_header_id,
1045: x_pk2_value => p_bid_number,
1046: x_delete_document_flag => 'Y');
1047: