1 PACKAGE pon_neg_styles_tl_pkg AUTHID CURRENT_USER AS
2 /* $Header: PONSTYLS.pls 120.5 2010/10/26 00:47:27 atjen ship $ */
3
4
5
6 PROCEDURE insert_row (
7 p_style_id IN pon_negotiation_styles.style_id%TYPE
8 ,p_status IN pon_negotiation_styles.status%TYPE
9 ,p_system_flag IN pon_negotiation_styles.system_flag%TYPE
10 ,p_line_attribute_enabled_flag IN pon_negotiation_styles.line_attribute_enabled_flag%TYPE
11 ,p_line_mas_enabled_flag IN pon_negotiation_styles.line_mas_enabled_flag%TYPE
12 ,p_price_element_enabled_flag IN pon_negotiation_styles.price_element_enabled_flag%TYPE
13 ,p_rfi_line_enabled_flag IN pon_negotiation_styles.rfi_line_enabled_flag%TYPE
14 ,p_lot_enabled_flag IN pon_negotiation_styles.lot_enabled_flag%TYPE
15 ,p_group_enabled_flag IN pon_negotiation_styles.group_enabled_flag%TYPE
16 ,p_large_neg_enabled_flag IN pon_negotiation_styles.large_neg_enabled_flag%TYPE
17 ,p_hdr_attribute_enabled_flag IN pon_negotiation_styles.hdr_attribute_enabled_flag%TYPE
18 ,p_neg_team_enabled_flag IN pon_negotiation_styles.neg_team_enabled_flag%TYPE
19 ,p_proxy_bidding_enabled_flag IN pon_negotiation_styles.proxy_bidding_enabled_flag%TYPE
20 ,p_power_bidding_enabled_flag IN pon_negotiation_styles.power_bidding_enabled_flag%TYPE
21 ,p_auto_extend_enabled_flag IN pon_negotiation_styles.auto_extend_enabled_flag%TYPE
22 ,p_team_scoring_enabled_flag IN pon_negotiation_styles.team_scoring_enabled_flag%TYPE
23 ,p_creation_date IN pon_negotiation_styles.creation_date%TYPE
24 ,p_created_by IN pon_negotiation_styles.created_by%TYPE
25 ,p_last_update_date IN pon_negotiation_styles.last_update_date%TYPE
26 ,p_last_updated_by IN pon_negotiation_styles.last_updated_by%TYPE
27 ,p_last_update_login IN pon_negotiation_styles.last_update_login%TYPE
28 ,p_qty_price_tiers_enabled_flag IN pon_negotiation_styles.qty_price_tiers_enabled_flag%TYPE
29 -------------------------- Supplier Management: Negotiation Styles --------------------------
30 ,p_supp_reg_qual_flag IN pon_negotiation_styles.supp_reg_qual_flag%TYPE
31 ,p_supp_eval_flag IN pon_negotiation_styles.supp_eval_flag%TYPE
32 ,p_hide_terms_flag IN pon_negotiation_styles.hide_terms_flag%TYPE
33 ,p_hide_abstract_forms_flag IN pon_negotiation_styles.hide_abstract_forms_flag%TYPE
34 ,p_hide_attachments_flag IN pon_negotiation_styles.hide_attachments_flag%TYPE
35 ,p_internal_eval_flag IN pon_negotiation_styles.internal_eval_flag%TYPE
36 ,p_hdr_supp_attr_enabled_flag IN pon_negotiation_styles.hdr_supp_attr_enabled_flag%TYPE
37 ,p_intgr_hdr_attr_flag IN pon_negotiation_styles.intgr_hdr_attr_flag%TYPE
38 ,p_intgr_hdr_attach_flag IN pon_negotiation_styles.intgr_hdr_attach_flag%TYPE
39 ,p_line_supp_attr_enabled_flag IN pon_negotiation_styles.line_supp_attr_enabled_flag%TYPE
40 ,p_item_supp_attr_enabled_flag IN pon_negotiation_styles.item_supp_attr_enabled_flag%TYPE
41 ,p_intgr_cat_line_attr_flag IN pon_negotiation_styles.intgr_cat_line_attr_flag%TYPE
42 ,p_intgr_item_line_attr_flag IN pon_negotiation_styles.intgr_item_line_attr_flag%TYPE
43 ,p_intgr_cat_line_asl_flag IN pon_negotiation_styles.intgr_cat_line_asl_flag%TYPE
44 ---------------------------------------------------------------------------------------------
45 ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE
46 ,p_description IN pon_negotiation_styles_tl.description%TYPE);
47
48 PROCEDURE update_row (
49 p_style_id IN pon_negotiation_styles.style_id%TYPE
50 ,p_status IN pon_negotiation_styles.status%TYPE
51 ,p_system_flag IN pon_negotiation_styles.system_flag%TYPE
52 ,p_line_attribute_enabled_flag IN pon_negotiation_styles.line_attribute_enabled_flag%TYPE
53 ,p_line_mas_enabled_flag IN pon_negotiation_styles.line_mas_enabled_flag%TYPE
54 ,p_price_element_enabled_flag IN pon_negotiation_styles.price_element_enabled_flag%TYPE
55 ,p_rfi_line_enabled_flag IN pon_negotiation_styles.rfi_line_enabled_flag%TYPE
56 ,p_lot_enabled_flag IN pon_negotiation_styles.lot_enabled_flag%TYPE
57 ,p_group_enabled_flag IN pon_negotiation_styles.group_enabled_flag%TYPE
58 ,p_large_neg_enabled_flag IN pon_negotiation_styles.large_neg_enabled_flag%TYPE
59 ,p_hdr_attribute_enabled_flag IN pon_negotiation_styles.hdr_attribute_enabled_flag%TYPE
60 ,p_neg_team_enabled_flag IN pon_negotiation_styles.neg_team_enabled_flag%TYPE
61 ,p_proxy_bidding_enabled_flag IN pon_negotiation_styles.proxy_bidding_enabled_flag%TYPE
62 ,p_power_bidding_enabled_flag IN pon_negotiation_styles.power_bidding_enabled_flag%TYPE
63 ,p_auto_extend_enabled_flag IN pon_negotiation_styles.auto_extend_enabled_flag%TYPE
64 ,p_team_scoring_enabled_flag IN pon_negotiation_styles.team_scoring_enabled_flag%TYPE
65 ,p_last_update_date IN pon_negotiation_styles.last_update_date%TYPE
66 ,p_last_updated_by IN pon_negotiation_styles.last_updated_by%TYPE
67 ,p_last_update_login IN pon_negotiation_styles.last_update_login%TYPE
68 ,p_qty_price_tiers_enabled_flag IN pon_negotiation_styles.qty_price_tiers_enabled_flag%TYPE
69 -------------------------- Supplier Management: Negotiation Styles --------------------------
70 ,p_supp_reg_qual_flag IN pon_negotiation_styles.supp_reg_qual_flag%TYPE
71 ,p_supp_eval_flag IN pon_negotiation_styles.supp_eval_flag%TYPE
72 ,p_hide_terms_flag IN pon_negotiation_styles.hide_terms_flag%TYPE
73 ,p_hide_abstract_forms_flag IN pon_negotiation_styles.hide_abstract_forms_flag%TYPE
74 ,p_hide_attachments_flag IN pon_negotiation_styles.hide_attachments_flag%TYPE
75 ,p_internal_eval_flag IN pon_negotiation_styles.internal_eval_flag%TYPE
76 ,p_hdr_supp_attr_enabled_flag IN pon_negotiation_styles.hdr_supp_attr_enabled_flag%TYPE
77 ,p_intgr_hdr_attr_flag IN pon_negotiation_styles.intgr_hdr_attr_flag%TYPE
78 ,p_intgr_hdr_attach_flag IN pon_negotiation_styles.intgr_hdr_attach_flag%TYPE
79 ,p_line_supp_attr_enabled_flag IN pon_negotiation_styles.line_supp_attr_enabled_flag%TYPE
80 ,p_item_supp_attr_enabled_flag IN pon_negotiation_styles.item_supp_attr_enabled_flag%TYPE
81 ,p_intgr_cat_line_attr_flag IN pon_negotiation_styles.intgr_cat_line_attr_flag%TYPE
82 ,p_intgr_item_line_attr_flag IN pon_negotiation_styles.intgr_item_line_attr_flag%TYPE
83 ,p_intgr_cat_line_asl_flag IN pon_negotiation_styles.intgr_cat_line_asl_flag%TYPE
84 ---------------------------------------------------------------------------------------------
85 ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE
86 ,p_description IN pon_negotiation_styles_tl.description%TYPE);
87
88 PROCEDURE translate_row (
89 p_style_id IN pon_negotiation_styles.style_id%TYPE
90 ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE
91 ,p_description IN pon_negotiation_styles_tl.description%TYPE
92 ,p_owner IN VARCHAR2
93 ,p_custom_mode IN VARCHAR2
94 ,p_last_update_date IN VARCHAR2);
95
96 PROCEDURE load_row (
97 p_style_id IN pon_negotiation_styles.style_id%TYPE
98 ,p_owner IN VARCHAR2
99 ,p_last_update_date IN VARCHAR2
100 ,p_custom_mode IN VARCHAR2
101 ,p_status IN pon_negotiation_styles.status%TYPE
102 ,p_system_flag IN pon_negotiation_styles.system_flag%TYPE
103 ,p_line_attribute_enabled_flag IN pon_negotiation_styles.line_attribute_enabled_flag%TYPE
104 ,p_line_mas_enabled_flag IN pon_negotiation_styles.line_mas_enabled_flag%TYPE
105 ,p_price_element_enabled_flag IN pon_negotiation_styles.price_element_enabled_flag%TYPE
106 ,p_rfi_line_enabled_flag IN pon_negotiation_styles.rfi_line_enabled_flag%TYPE
107 ,p_lot_enabled_flag IN pon_negotiation_styles.lot_enabled_flag%TYPE
108 ,p_group_enabled_flag IN pon_negotiation_styles.group_enabled_flag%TYPE
109 ,p_large_neg_enabled_flag IN pon_negotiation_styles.large_neg_enabled_flag%TYPE
110 ,p_hdr_attribute_enabled_flag IN pon_negotiation_styles.hdr_attribute_enabled_flag%TYPE
111 ,p_neg_team_enabled_flag IN pon_negotiation_styles.neg_team_enabled_flag%TYPE
112 ,p_proxy_bidding_enabled_flag IN pon_negotiation_styles.proxy_bidding_enabled_flag%TYPE
113 ,p_power_bidding_enabled_flag IN pon_negotiation_styles.power_bidding_enabled_flag%TYPE
114 ,p_auto_extend_enabled_flag IN pon_negotiation_styles.auto_extend_enabled_flag%TYPE
115 ,p_team_scoring_enabled_flag IN pon_negotiation_styles.team_scoring_enabled_flag%TYPE
116 ,p_qty_price_tiers_enabled_flag IN pon_negotiation_styles.qty_price_tiers_enabled_flag%TYPE
117 -------------------------- Supplier Management: Negotiation Styles --------------------------
118 ,p_supp_reg_qual_flag IN pon_negotiation_styles.supp_reg_qual_flag%TYPE
119 ,p_supp_eval_flag IN pon_negotiation_styles.supp_eval_flag%TYPE
120 ,p_hide_terms_flag IN pon_negotiation_styles.hide_terms_flag%TYPE
121 ,p_hide_abstract_forms_flag IN pon_negotiation_styles.hide_abstract_forms_flag%TYPE
122 ,p_hide_attachments_flag IN pon_negotiation_styles.hide_attachments_flag%TYPE
123 ,p_internal_eval_flag IN pon_negotiation_styles.internal_eval_flag%TYPE
124 ,p_hdr_supp_attr_enabled_flag IN pon_negotiation_styles.hdr_supp_attr_enabled_flag%TYPE
125 ,p_intgr_hdr_attr_flag IN pon_negotiation_styles.intgr_hdr_attr_flag%TYPE
126 ,p_intgr_hdr_attach_flag IN pon_negotiation_styles.intgr_hdr_attach_flag%TYPE
127 ,p_line_supp_attr_enabled_flag IN pon_negotiation_styles.line_supp_attr_enabled_flag%TYPE
128 ,p_item_supp_attr_enabled_flag IN pon_negotiation_styles.item_supp_attr_enabled_flag%TYPE
129 ,p_intgr_cat_line_attr_flag IN pon_negotiation_styles.intgr_cat_line_attr_flag%TYPE
130 ,p_intgr_item_line_attr_flag IN pon_negotiation_styles.intgr_item_line_attr_flag%TYPE
131 ,p_intgr_cat_line_asl_flag IN pon_negotiation_styles.intgr_cat_line_asl_flag%TYPE
132 ---------------------------------------------------------------------------------------------
133 ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE
134 ,p_description IN pon_negotiation_styles_tl.description%TYPE);
135
136 PROCEDURE delete_row (
137 p_style_id IN pon_negotiation_styles.style_id%TYPE
138 );
139
140 PROCEDURE add_language;
141
142 END pon_neg_styles_tl_pkg;