1 PACKAGE pon_negotiation_publish_pvt AUTHID CURRENT_USER AS
2 /* $Header: PONNEGPS.pls 120.8.12020000.2 2013/02/09 11:01:19 hvutukur 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 --- CLM - Clin Slin project Changes Start.
68 PROCEDURE GET_CLIN_GRP_MAX_DISP_LINE_NUM (
69 p_auction_header_id IN NUMBER,
70 p_parent_line_number IN NUMBER,
71 x_max_disp_line_number OUT NOCOPY NUMBER
72 );
73 --- CLM - Clin Slin project Changes End.
74
75 PROCEDURE update_before_publish (
76 x_result OUT NOCOPY VARCHAR2,
77 x_error_code OUT NOCOPY VARCHAR2,
78 x_error_message OUT NOCOPY VARCHAR2,
79 p_auction_header_id IN NUMBER,
80 p_close_bidding_date IN DATE,
81 p_user_id IN NUMBER,
82 p_login_id IN NUMBER);
83
84 FUNCTION IS_PROJECT_SPONSORED (
85 p_project_id IN NUMBER
86 ) RETURN VARCHAR2;
87
88 PROCEDURE VALIDATE_PROJECTS_DETAILS (
89 p_project_id IN NUMBER,
90 p_task_id IN NUMBER,
91 p_expenditure_date IN DATE,
92 p_expenditure_type IN VARCHAR2,
93 p_expenditure_org IN NUMBER,
94 p_person_id IN NUMBER,
95 p_auction_header_id IN NUMBER,
96 p_line_number IN NUMBER,
97 p_document_disp_line_number IN VARCHAR2,
98 p_payment_id IN NUMBER,
99 p_interface_line_id IN NUMBER,
100 p_payment_display_number IN NUMBER,
101 p_batch_id IN NUMBER,
102 p_table_name IN VARCHAR2,
103 p_interface_type IN VARCHAR2,
104 p_entity_type IN VARCHAR2,
105 p_called_from IN VARCHAR2
106 );
107
108 --Complex work
109 -- This procedure nullifies the attributes that should not be populated
110 --if a supplier is allowed to enter payments and also deletes the attachments to
111 -- those payments
112 PROCEDURE Process_Payments (
113 x_result OUT NOCOPY VARCHAR,
114 x_error_code OUT NOCOPY VARCHAR,
115 x_error_message OUT NOCOPY VARCHAR,
116 p_auction_header_id IN NUMBER,
117 p_user_id IN NUMBER,
118 p_login_id IN NUMBER
119 );
120
121 END PON_NEGOTIATION_PUBLISH_PVT;
[Home] [Help]