1 PACKAGE PON_NEGOTIATION_PUBLISH_PVT AS
2 /* $Header: PONNEGPS.pls 120.7 2007/03/12 14:58:49 tarkumar ship $ */
3
4 PROCEDURE PON_PUBLISH_SUPER_LARGE_NEG (
5 ERRBUF OUT NOCOPY VARCHAR2,
6 RETCODE OUT NOCOPY VARCHAR2,
7 ARGUMENT1 IN NUMBER, -- P_AUCTION_HEADER_ID
8 ARGUMENT2 IN VARCHAR2, -- P_FOR_APPROVAL
9 ARGUMENT3 IN VARCHAR2, -- P_NOTE_TO_APPROVERS
10 ARGUMENT4 IN VARCHAR2, -- P_ENCRYPTED_AUCTION_HEADER_ID
11 ARGUMENT5 IN VARCHAR2, -- P_USER_NAME
12 ARGUMENT6 IN NUMBER, -- P_USER_ID
13 ARGUMENT7 IN VARCHAR2, --p_client_timezone
14 ARGUMENT8 IN VARCHAR2, --p_server_timezone
15 ARGUMENT9 IN VARCHAR2, --p_date_format_mask
16 ARGUMENT10 IN VARCHAR2, --p_user_party_id
17 ARGUMENT11 IN VARCHAR2, --p_company_party_id
18 ARGUMENT12 IN VARCHAR2 --p_curr_language_code
19 );
20
21 PROCEDURE HAS_TEMP_LABOR_LINES (
22 p_auction_header_id IN NUMBER,
23 x_return_value OUT NOCOPY VARCHAR2
24 );
25
26
27 PROCEDURE VALIDATE_LINES (
28 x_result OUT NOCOPY VARCHAR2, --1
29 x_error_code OUT NOCOPY VARCHAR2, --2
30 x_error_message OUT NOCOPY VARCHAR2, --3
31 p_auction_header_id IN NUMBER, --4
32 p_doctype_id IN NUMBER, --5
33 p_auction_currency_precision IN NUMBER, --6
34 p_fnd_currency_precision IN NUMBER, --7
35 p_close_bidding_date IN DATE, --8
36 p_contract_type IN VARCHAR2, --9
37 p_global_agreement_flag IN VARCHAR2, --10
38 p_allow_other_bid_currency IN VARCHAR2, --11
39 p_bid_ranking IN VARCHAR2, --12
40 p_po_start_date IN DATE, --13
41 p_po_end_date IN DATE, --14
42 p_trading_partner_id IN NUMBER, --15
43 p_full_quantity_bid_code IN VARCHAR2, --16
44 p_invitees_count IN NUMBER, --17
45 p_bid_list_type IN VARCHAR2, --18
46 p_request_id IN NUMBER, --19
47 p_for_approval IN VARCHAR2, --20
48 p_user_id IN NUMBER, --21
49 p_line_attribute_enabled_flag IN VARCHAR2, --22
50 p_pf_type_allowed IN VARCHAR2, --23
51 p_progress_payment_type IN VARCHAR2, --24
52 p_large_neg_enabled_flag IN VARCHAR2, --25
53 p_price_tiers_indicator IN VARCHAR2, --26
54 x_batch_id OUT NOCOPY NUMBER --27
55 );
56
57 PROCEDURE SET_ITEM_HAS_CHILDREN_FLAGS (
58 p_auction_header_id IN NUMBER,
59 p_close_bidding_date IN DATE);
60
61 PROCEDURE GET_LOT_GRP_MAX_DISP_LINE_NUM (
62 p_auction_header_id IN NUMBER,
63 p_parent_line_number IN NUMBER,
64 x_max_disp_line_number OUT NOCOPY NUMBER
65 );
66
67 PROCEDURE update_before_publish (
68 x_result OUT NOCOPY VARCHAR2,
69 x_error_code OUT NOCOPY VARCHAR2,
70 x_error_message OUT NOCOPY VARCHAR2,
71 p_auction_header_id IN NUMBER,
72 p_close_bidding_date IN DATE,
73 p_user_id IN NUMBER,
74 p_login_id IN NUMBER);
75
76 FUNCTION IS_PROJECT_SPONSORED (
77 p_project_id IN NUMBER
78 ) RETURN VARCHAR2;
79
80 PROCEDURE VALIDATE_PROJECTS_DETAILS (
81 p_project_id IN NUMBER,
82 p_task_id IN NUMBER,
83 p_expenditure_date IN DATE,
84 p_expenditure_type IN VARCHAR2,
85 p_expenditure_org IN NUMBER,
86 p_person_id IN NUMBER,
87 p_auction_header_id IN NUMBER,
88 p_line_number IN NUMBER,
89 p_document_disp_line_number IN VARCHAR2,
90 p_payment_id IN NUMBER,
91 p_interface_line_id IN NUMBER,
92 p_payment_display_number IN NUMBER,
93 p_batch_id IN NUMBER,
94 p_table_name IN VARCHAR2,
95 p_interface_type IN VARCHAR2,
96 p_entity_type IN VARCHAR2,
97 p_called_from IN VARCHAR2
98 );
99
100 --Complex work
101 -- This procedure nullifies the attributes that should not be populated
102 --if a supplier is allowed to enter payments and also deletes the attachments to
103 -- those payments
104 PROCEDURE Process_Payments (
105 x_result OUT NOCOPY VARCHAR,
106 x_error_code OUT NOCOPY VARCHAR,
107 x_error_message OUT NOCOPY VARCHAR,
108 p_auction_header_id IN NUMBER,
109 p_user_id IN NUMBER,
110 p_login_id IN NUMBER
111 );
112
113 END PON_NEGOTIATION_PUBLISH_PVT;
114