18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy cm_line_tbl_type_cover%type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: ) as
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy cm_line_tbl_type_cover%type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: ) as
27: ddindx binary_integer; indx binary_integer;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy cm_line_tbl_type_cover%type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy cm_line_tbl_type_cover%type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin
29: if a0 is not null and a0.count > 0 then
43: end loop;
44: end if;
45: end if;
46: end rosetta_table_copy_in_p1;
47: procedure rosetta_table_copy_out_p1(t cm_line_tbl_type_cover%type, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_NUMBER_TABLE
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: ) as
44: end if;
45: end if;
46: end rosetta_table_copy_in_p1;
47: procedure rosetta_table_copy_out_p1(t cm_line_tbl_type_cover%type, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_NUMBER_TABLE
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: ) as
52: ddindx binary_integer; indx binary_integer;
45: end if;
46: end rosetta_table_copy_in_p1;
47: procedure rosetta_table_copy_out_p1(t cm_line_tbl_type_cover%type, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_NUMBER_TABLE
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin
46: end rosetta_table_copy_in_p1;
47: procedure rosetta_table_copy_out_p1(t cm_line_tbl_type_cover%type, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_NUMBER_TABLE
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin
54: if t is null or t.count = 0 then
51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin
54: if t is null or t.count = 0 then
55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_NUMBER_TABLE();
59: else
52: ddindx binary_integer; indx binary_integer;
53: begin
54: if t is null or t.count = 0 then
55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_NUMBER_TABLE();
59: else
60: a0 := JTF_NUMBER_TABLE();
53: begin
54: if t is null or t.count = 0 then
55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_NUMBER_TABLE();
59: else
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
54: if t is null or t.count = 0 then
55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_NUMBER_TABLE();
59: else
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_NUMBER_TABLE();
59: else
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: if t.count > 0 then
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_NUMBER_TABLE();
59: else
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: if t.count > 0 then
65: a0.extend(t.count);
58: a3 := JTF_NUMBER_TABLE();
59: else
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: if t.count > 0 then
65: a0.extend(t.count);
66: a1.extend(t.count);
59: else
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: if t.count > 0 then
65: a0.extend(t.count);
66: a1.extend(t.count);
67: a2.extend(t.count);
215: , p_tax_ex_cert_num VARCHAR2
216: , p_request_url VARCHAR2
217: , p_transaction_url VARCHAR2
218: , p_trans_act_url VARCHAR2
219: , p19_a0 JTF_NUMBER_TABLE
220: , p_skip_workflow_flag VARCHAR2
221: , p_credit_method_installments VARCHAR2
222: , p_credit_method_rules VARCHAR2
223: , p_batch_source_name VARCHAR2
222: , p_credit_method_rules VARCHAR2
223: , p_batch_source_name VARCHAR2
224: , p_org_id NUMBER
225: , x_request_id out nocopy VARCHAR2
226: , p19_a1 JTF_NUMBER_TABLE
227: , p19_a2 JTF_NUMBER_TABLE
228: , p19_a3 JTF_NUMBER_TABLE
229: , p_dispute_date DATE
230: , p_internal_comment VARCHAR2
223: , p_batch_source_name VARCHAR2
224: , p_org_id NUMBER
225: , x_request_id out nocopy VARCHAR2
226: , p19_a1 JTF_NUMBER_TABLE
227: , p19_a2 JTF_NUMBER_TABLE
228: , p19_a3 JTF_NUMBER_TABLE
229: , p_dispute_date DATE
230: , p_internal_comment VARCHAR2
231: )
224: , p_org_id NUMBER
225: , x_request_id out nocopy VARCHAR2
226: , p19_a1 JTF_NUMBER_TABLE
227: , p19_a2 JTF_NUMBER_TABLE
228: , p19_a3 JTF_NUMBER_TABLE
229: , p_dispute_date DATE
230: , p_internal_comment VARCHAR2
231: )
232: as
327: , p_comments VARCHAR2
328: , p_request_url VARCHAR2
329: , p_transaction_url VARCHAR2
330: , p_trans_act_url VARCHAR2
331: , p10_a0 JTF_NUMBER_TABLE
332: , p_org_id NUMBER
333: , l_val_return_status out nocopy VARCHAR2
334: , p_skip_workflow_flag VARCHAR2
335: , p_batch_source_name VARCHAR2
332: , p_org_id NUMBER
333: , l_val_return_status out nocopy VARCHAR2
334: , p_skip_workflow_flag VARCHAR2
335: , p_batch_source_name VARCHAR2
336: , p10_a1 JTF_NUMBER_TABLE
337: , p10_a2 JTF_NUMBER_TABLE
338: , p10_a3 JTF_NUMBER_TABLE
339: , p_dispute_date DATE
340: )
333: , l_val_return_status out nocopy VARCHAR2
334: , p_skip_workflow_flag VARCHAR2
335: , p_batch_source_name VARCHAR2
336: , p10_a1 JTF_NUMBER_TABLE
337: , p10_a2 JTF_NUMBER_TABLE
338: , p10_a3 JTF_NUMBER_TABLE
339: , p_dispute_date DATE
340: )
341: as
334: , p_skip_workflow_flag VARCHAR2
335: , p_batch_source_name VARCHAR2
336: , p10_a1 JTF_NUMBER_TABLE
337: , p10_a2 JTF_NUMBER_TABLE
338: , p10_a3 JTF_NUMBER_TABLE
339: , p_dispute_date DATE
340: )
341: as
342: ddp_cm_line_tbl cm_line_tbl_type_cover%type;