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 56: p_bid_number IN pon_bid_headers.bid_number%TYPE,

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

Line 122: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,

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

Line 123: p_bid_number IN pon_bid_headers.bid_number%TYPE

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

Line 486: p_bid_number IN pon_bid_headers.bid_number%TYPE

482: -- the bid is pending or completed
483: -- ======================================================================
484: FUNCTION is_bid_request_pending
485: (
486: p_bid_number IN pon_bid_headers.bid_number%TYPE
487: ) RETURN VARCHAR2 IS
488: l_request_id pon_bid_headers.request_id%TYPE;
489: BEGIN
490:

Line 488: l_request_id pon_bid_headers.request_id%TYPE;

484: FUNCTION is_bid_request_pending
485: (
486: p_bid_number IN pon_bid_headers.bid_number%TYPE
487: ) RETURN VARCHAR2 IS
488: l_request_id pon_bid_headers.request_id%TYPE;
489: BEGIN
490:
491: SELECT request_id
492: INTO l_request_id

Line 493: FROM pon_bid_headers

489: BEGIN
490:
491: SELECT request_id
492: INTO l_request_id
493: FROM pon_bid_headers
494: WHERE bid_number = p_bid_number;
495:
496: IF (l_request_id IS null) THEN
497: RETURN 'N';

Line 976: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,

972: -- bid headers.
973: -- ======================================================================
974: PROCEDURE delete_bid_by_header
975: (
976: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
977: p_bid_number IN pon_bid_headers.bid_number%TYPE,
978: P_doc_type IN varchar2,
979: x_msg_count OUT NOCOPY NUMBER,
980: x_return_status OUT NOCOPY VARCHAR2,

Line 977: p_bid_number IN pon_bid_headers.bid_number%TYPE,

973: -- ======================================================================
974: PROCEDURE delete_bid_by_header
975: (
976: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
977: p_bid_number IN pon_bid_headers.bid_number%TYPE,
978: P_doc_type IN varchar2,
979: x_msg_count OUT NOCOPY NUMBER,
980: x_return_status OUT NOCOPY VARCHAR2,
981: x_msg_data OUT NOCOPY VARCHAR2

Line 1028: delete from pon_bid_headers where bid_number = p_bid_number;

1024: p_bid_number => p_bid_number
1025: );
1026:
1027: -- Delete bid header
1028: delete from pon_bid_headers where bid_number = p_bid_number;
1029:
1030: EXCEPTION
1031: WHEN PON_FAIL_CALL_DEL_DOC THEN
1032: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1049: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,

1045:
1046: -- Delete bid header attachment
1047: PROCEDURE delete_bid_header_attachment
1048: (
1049: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
1050: p_bid_number IN pon_bid_headers.bid_number%TYPE
1051:
1052: ) IS
1053: BEGIN

Line 1050: p_bid_number IN pon_bid_headers.bid_number%TYPE

1046: -- Delete bid header attachment
1047: PROCEDURE delete_bid_header_attachment
1048: (
1049: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
1050: p_bid_number IN pon_bid_headers.bid_number%TYPE
1051:
1052: ) IS
1053: BEGIN
1054:

Line 1057: (x_entity_name => 'PON_BID_HEADERS',

1053: BEGIN
1054:
1055: -- Delete bid header attachment
1056: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
1057: (x_entity_name => 'PON_BID_HEADERS',
1058: x_pk1_value => p_auc_header_id,
1059: x_pk2_value => p_bid_number,
1060: x_delete_document_flag => 'Y');
1061: