DBA Data[Home] [Help]

APPS.IBE_ORDER_UTIL_PVT dependencies on JTF_NUMBER_TABLE

Line 13: x_rec_subtotal OUT NOCOPY JTF_NUMBER_TABLE,

9: p_header_id IN NUMBER,
10: x_charge_periodicity_code OUT NOCOPY JTF_VARCHAR2_TABLE_300,
11: x_charge_periodicity_desc OUT NOCOPY JTF_VARCHAR2_TABLE_300,
12: x_charge_periodicity_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_300,
13: x_rec_subtotal OUT NOCOPY JTF_NUMBER_TABLE,
14: x_rec_tax OUT NOCOPY JTF_NUMBER_TABLE,
15: x_rec_charges OUT NOCOPY JTF_NUMBER_TABLE,
16: x_rec_total OUT NOCOPY JTF_NUMBER_TABLE,
17: x_return_status OUT NOCOPY VARCHAR2,

Line 14: x_rec_tax OUT NOCOPY JTF_NUMBER_TABLE,

10: x_charge_periodicity_code OUT NOCOPY JTF_VARCHAR2_TABLE_300,
11: x_charge_periodicity_desc OUT NOCOPY JTF_VARCHAR2_TABLE_300,
12: x_charge_periodicity_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_300,
13: x_rec_subtotal OUT NOCOPY JTF_NUMBER_TABLE,
14: x_rec_tax OUT NOCOPY JTF_NUMBER_TABLE,
15: x_rec_charges OUT NOCOPY JTF_NUMBER_TABLE,
16: x_rec_total OUT NOCOPY JTF_NUMBER_TABLE,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,

Line 15: x_rec_charges OUT NOCOPY JTF_NUMBER_TABLE,

11: x_charge_periodicity_desc OUT NOCOPY JTF_VARCHAR2_TABLE_300,
12: x_charge_periodicity_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_300,
13: x_rec_subtotal OUT NOCOPY JTF_NUMBER_TABLE,
14: x_rec_tax OUT NOCOPY JTF_NUMBER_TABLE,
15: x_rec_charges OUT NOCOPY JTF_NUMBER_TABLE,
16: x_rec_total OUT NOCOPY JTF_NUMBER_TABLE,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2

Line 16: x_rec_total OUT NOCOPY JTF_NUMBER_TABLE,

12: x_charge_periodicity_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_300,
13: x_rec_subtotal OUT NOCOPY JTF_NUMBER_TABLE,
14: x_rec_tax OUT NOCOPY JTF_NUMBER_TABLE,
15: x_rec_charges OUT NOCOPY JTF_NUMBER_TABLE,
16: x_rec_total OUT NOCOPY JTF_NUMBER_TABLE,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2
20: )

Line 30: x_rec_subtotal := JTF_NUMBER_TABLE();

26: BEGIN
27: x_charge_periodicity_code := JTF_VARCHAR2_TABLE_300();
28: x_charge_periodicity_desc := JTF_VARCHAR2_TABLE_300();
29: x_charge_periodicity_meaning := JTF_VARCHAR2_TABLE_300();
30: x_rec_subtotal := JTF_NUMBER_TABLE();
31: x_rec_tax := JTF_NUMBER_TABLE();
32: x_rec_charges := JTF_NUMBER_TABLE();
33: x_rec_total := JTF_NUMBER_TABLE();
34:

Line 31: x_rec_tax := JTF_NUMBER_TABLE();

27: x_charge_periodicity_code := JTF_VARCHAR2_TABLE_300();
28: x_charge_periodicity_desc := JTF_VARCHAR2_TABLE_300();
29: x_charge_periodicity_meaning := JTF_VARCHAR2_TABLE_300();
30: x_rec_subtotal := JTF_NUMBER_TABLE();
31: x_rec_tax := JTF_NUMBER_TABLE();
32: x_rec_charges := JTF_NUMBER_TABLE();
33: x_rec_total := JTF_NUMBER_TABLE();
34:
35: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 32: x_rec_charges := JTF_NUMBER_TABLE();

28: x_charge_periodicity_desc := JTF_VARCHAR2_TABLE_300();
29: x_charge_periodicity_meaning := JTF_VARCHAR2_TABLE_300();
30: x_rec_subtotal := JTF_NUMBER_TABLE();
31: x_rec_tax := JTF_NUMBER_TABLE();
32: x_rec_charges := JTF_NUMBER_TABLE();
33: x_rec_total := JTF_NUMBER_TABLE();
34:
35: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
36: IBE_Util.Debug('In Get_Ord_Recurring_totals : After Initializations. Calling OE_Totals_GRP.GET_RECURRING_TOTALS');

Line 33: x_rec_total := JTF_NUMBER_TABLE();

29: x_charge_periodicity_meaning := JTF_VARCHAR2_TABLE_300();
30: x_rec_subtotal := JTF_NUMBER_TABLE();
31: x_rec_tax := JTF_NUMBER_TABLE();
32: x_rec_charges := JTF_NUMBER_TABLE();
33: x_rec_total := JTF_NUMBER_TABLE();
34:
35: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
36: IBE_Util.Debug('In Get_Ord_Recurring_totals : After Initializations. Calling OE_Totals_GRP.GET_RECURRING_TOTALS');
37: END IF;

Line 90: x_price_adjustment_id OUT NOCOPY jtf_number_table ,

86: x_arithmetic_operator OUT NOCOPY JTF_VARCHAR2_TABLE_300 ,
87: x_return_status OUT NOCOPY VARCHAR2,
88: p_header_id IN NUMBER,
89: p_line_id IN NUMBER,
90: x_price_adjustment_id OUT NOCOPY jtf_number_table ,
91: x_operand OUT NOCOPY jtf_number_table ,
92: x_unit_discount_amount OUT NOCOPY jtf_number_table,
93: x_count_lines OUT NOCOPY number
94: )IS

Line 91: x_operand OUT NOCOPY jtf_number_table ,

87: x_return_status OUT NOCOPY VARCHAR2,
88: p_header_id IN NUMBER,
89: p_line_id IN NUMBER,
90: x_price_adjustment_id OUT NOCOPY jtf_number_table ,
91: x_operand OUT NOCOPY jtf_number_table ,
92: x_unit_discount_amount OUT NOCOPY jtf_number_table,
93: x_count_lines OUT NOCOPY number
94: )IS
95:

Line 92: x_unit_discount_amount OUT NOCOPY jtf_number_table,

88: p_header_id IN NUMBER,
89: p_line_id IN NUMBER,
90: x_price_adjustment_id OUT NOCOPY jtf_number_table ,
91: x_operand OUT NOCOPY jtf_number_table ,
92: x_unit_discount_amount OUT NOCOPY jtf_number_table,
93: x_count_lines OUT NOCOPY number
94: )IS
95:
96: l_adj_detail_tbl OE_Header_Adj_Util.line_adjustments_tab_type ;

Line 103: x_price_adjustment_id := JTF_NUMBER_TABLE();

99: BEGIN
100: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
101: IBE_Util.Debug('In Get_Adjustments : Start');
102: END IF;
103: x_price_adjustment_id := JTF_NUMBER_TABLE();
104: x_adjustment_name := JTF_VARCHAR2_TABLE_300();
105: x_adjustment_description := JTF_VARCHAR2_TABLE_2000();
106: x_list_line_no := JTF_VARCHAR2_TABLE_300();
107: x_adjustment_type_code := JTF_VARCHAR2_TABLE_300();

Line 108: x_operand := JTF_NUMBER_TABLE();

104: x_adjustment_name := JTF_VARCHAR2_TABLE_300();
105: x_adjustment_description := JTF_VARCHAR2_TABLE_2000();
106: x_list_line_no := JTF_VARCHAR2_TABLE_300();
107: x_adjustment_type_code := JTF_VARCHAR2_TABLE_300();
108: x_operand := JTF_NUMBER_TABLE();
109: x_arithmetic_operator := JTF_VARCHAR2_TABLE_300();
110: x_unit_discount_amount := JTF_NUMBER_TABLE();
111:
112: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 110: x_unit_discount_amount := JTF_NUMBER_TABLE();

106: x_list_line_no := JTF_VARCHAR2_TABLE_300();
107: x_adjustment_type_code := JTF_VARCHAR2_TABLE_300();
108: x_operand := JTF_NUMBER_TABLE();
109: x_arithmetic_operator := JTF_VARCHAR2_TABLE_300();
110: x_unit_discount_amount := JTF_NUMBER_TABLE();
111:
112: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
113: IBE_Util.Debug('In Get_Adjustments : After Initializations. Calling oe_lineinfo_grp.Get_Adjustments');
114: END IF;

Line 162: x_top_model_line_id OUT NOCOPY JTF_NUMBER_TABLE,

158:
159: -- Procedure to get whether the top models are reconfigured or not fiven a header id
160: PROCEDURE Get_MACD_Action_Mode
161: ( p_header_id IN NUMBER,
162: x_top_model_line_id OUT NOCOPY JTF_NUMBER_TABLE,
163: x_line_is_reconfig OUT NOCOPY JTF_VARCHAR2_TABLE_100,
164: x_return_status OUT NOCOPY VARCHAR2
165: )IS
166: -- Define the variables

Line 189: x_top_model_line_id := JTF_NUMBER_TABLE();

185: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
186: IBE_Util.Debug('In Get_MACD_Action_Mode : Start');
187: END IF;
188:
189: x_top_model_line_id := JTF_NUMBER_TABLE();
190: x_line_is_reconfig := JTF_VARCHAR2_TABLE_100();
191:
192: OPEN c_top_model(P_header_id);
193: LOOP