1 PACKAGE pon_neg_styles_tl_pkg AS
2 /* $Header: PONSTYLS.pls 120.3 2007/04/05 14:41:58 tarkumar 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 ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE
30 ,p_description IN pon_negotiation_styles_tl.description%TYPE);
31
32 PROCEDURE update_row (
33 p_style_id IN pon_negotiation_styles.style_id%TYPE
34 ,p_status IN pon_negotiation_styles.status%TYPE
35 ,p_system_flag IN pon_negotiation_styles.system_flag%TYPE
36 ,p_line_attribute_enabled_flag IN pon_negotiation_styles.line_attribute_enabled_flag%TYPE
37 ,p_line_mas_enabled_flag IN pon_negotiation_styles.line_mas_enabled_flag%TYPE
38 ,p_price_element_enabled_flag IN pon_negotiation_styles.price_element_enabled_flag%TYPE
39 ,p_rfi_line_enabled_flag IN pon_negotiation_styles.rfi_line_enabled_flag%TYPE
40 ,p_lot_enabled_flag IN pon_negotiation_styles.lot_enabled_flag%TYPE
41 ,p_group_enabled_flag IN pon_negotiation_styles.group_enabled_flag%TYPE
42 ,p_large_neg_enabled_flag IN pon_negotiation_styles.large_neg_enabled_flag%TYPE
43 ,p_hdr_attribute_enabled_flag IN pon_negotiation_styles.hdr_attribute_enabled_flag%TYPE
44 ,p_neg_team_enabled_flag IN pon_negotiation_styles.neg_team_enabled_flag%TYPE
45 ,p_proxy_bidding_enabled_flag IN pon_negotiation_styles.proxy_bidding_enabled_flag%TYPE
46 ,p_power_bidding_enabled_flag IN pon_negotiation_styles.power_bidding_enabled_flag%TYPE
47 ,p_auto_extend_enabled_flag IN pon_negotiation_styles.auto_extend_enabled_flag%TYPE
48 ,p_team_scoring_enabled_flag IN pon_negotiation_styles.team_scoring_enabled_flag%TYPE
49 ,p_last_update_date IN pon_negotiation_styles.last_update_date%TYPE
50 ,p_last_updated_by IN pon_negotiation_styles.last_updated_by%TYPE
51 ,p_last_update_login IN pon_negotiation_styles.last_update_login%TYPE
52 ,p_qty_price_tiers_enabled_flag IN pon_negotiation_styles.qty_price_tiers_enabled_flag%TYPE
53 ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE
54 ,p_description IN pon_negotiation_styles_tl.description%TYPE);
55
56 PROCEDURE translate_row (
57 p_style_id IN pon_negotiation_styles.style_id%TYPE
58 ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE
59 ,p_description IN pon_negotiation_styles_tl.description%TYPE
60 ,p_owner IN VARCHAR2
61 ,p_custom_mode IN VARCHAR2
62 ,p_last_update_date IN VARCHAR2);
63
64 PROCEDURE load_row (
65 p_style_id IN pon_negotiation_styles.style_id%TYPE
66 ,p_owner IN VARCHAR2
67 ,p_last_update_date IN VARCHAR2
68 ,p_custom_mode IN VARCHAR2
69 ,p_status IN pon_negotiation_styles.status%TYPE
70 ,p_system_flag IN pon_negotiation_styles.system_flag%TYPE
71 ,p_line_attribute_enabled_flag IN pon_negotiation_styles.line_attribute_enabled_flag%TYPE
72 ,p_line_mas_enabled_flag IN pon_negotiation_styles.line_mas_enabled_flag%TYPE
73 ,p_price_element_enabled_flag IN pon_negotiation_styles.price_element_enabled_flag%TYPE
74 ,p_rfi_line_enabled_flag IN pon_negotiation_styles.rfi_line_enabled_flag%TYPE
75 ,p_lot_enabled_flag IN pon_negotiation_styles.lot_enabled_flag%TYPE
76 ,p_group_enabled_flag IN pon_negotiation_styles.group_enabled_flag%TYPE
77 ,p_large_neg_enabled_flag IN pon_negotiation_styles.large_neg_enabled_flag%TYPE
78 ,p_hdr_attribute_enabled_flag IN pon_negotiation_styles.hdr_attribute_enabled_flag%TYPE
79 ,p_neg_team_enabled_flag IN pon_negotiation_styles.neg_team_enabled_flag%TYPE
80 ,p_proxy_bidding_enabled_flag IN pon_negotiation_styles.proxy_bidding_enabled_flag%TYPE
81 ,p_power_bidding_enabled_flag IN pon_negotiation_styles.power_bidding_enabled_flag%TYPE
82 ,p_auto_extend_enabled_flag IN pon_negotiation_styles.auto_extend_enabled_flag%TYPE
83 ,p_team_scoring_enabled_flag IN pon_negotiation_styles.team_scoring_enabled_flag%TYPE
84 ,p_qty_price_tiers_enabled_flag IN pon_negotiation_styles.qty_price_tiers_enabled_flag%TYPE
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 delete_row (
89 p_style_id IN pon_negotiation_styles.style_id%TYPE
90 );
91
92 PROCEDURE add_language;
93
94 END pon_neg_styles_tl_pkg;