2: /* $Header: ARTUFLXS.pls 115.2 2002/11/15 04:04:38 anukumar ship $ */
3:
4: FUNCTION unique_trans_flex(
5: p_ctl_id IN
6: ra_customer_trx_lines.customer_trx_line_id%type,
7: p_interface_line_context IN
8: ra_customer_trx_lines.interface_line_context%type,
9: p_interface_line_attribute1 IN
10: ra_customer_trx_lines.interface_line_attribute1%type,
4: FUNCTION unique_trans_flex(
5: p_ctl_id IN
6: ra_customer_trx_lines.customer_trx_line_id%type,
7: p_interface_line_context IN
8: ra_customer_trx_lines.interface_line_context%type,
9: p_interface_line_attribute1 IN
10: ra_customer_trx_lines.interface_line_attribute1%type,
11: p_interface_line_attribute2 IN
12: ra_customer_trx_lines.interface_line_attribute2%type,
6: ra_customer_trx_lines.customer_trx_line_id%type,
7: p_interface_line_context IN
8: ra_customer_trx_lines.interface_line_context%type,
9: p_interface_line_attribute1 IN
10: ra_customer_trx_lines.interface_line_attribute1%type,
11: p_interface_line_attribute2 IN
12: ra_customer_trx_lines.interface_line_attribute2%type,
13: p_interface_line_attribute3 IN
14: ra_customer_trx_lines.interface_line_attribute3%type,
8: ra_customer_trx_lines.interface_line_context%type,
9: p_interface_line_attribute1 IN
10: ra_customer_trx_lines.interface_line_attribute1%type,
11: p_interface_line_attribute2 IN
12: ra_customer_trx_lines.interface_line_attribute2%type,
13: p_interface_line_attribute3 IN
14: ra_customer_trx_lines.interface_line_attribute3%type,
15: p_interface_line_attribute4 IN
16: ra_customer_trx_lines.interface_line_attribute4%type,
10: ra_customer_trx_lines.interface_line_attribute1%type,
11: p_interface_line_attribute2 IN
12: ra_customer_trx_lines.interface_line_attribute2%type,
13: p_interface_line_attribute3 IN
14: ra_customer_trx_lines.interface_line_attribute3%type,
15: p_interface_line_attribute4 IN
16: ra_customer_trx_lines.interface_line_attribute4%type,
17: p_interface_line_attribute5 IN
18: ra_customer_trx_lines.interface_line_attribute5%type,
12: ra_customer_trx_lines.interface_line_attribute2%type,
13: p_interface_line_attribute3 IN
14: ra_customer_trx_lines.interface_line_attribute3%type,
15: p_interface_line_attribute4 IN
16: ra_customer_trx_lines.interface_line_attribute4%type,
17: p_interface_line_attribute5 IN
18: ra_customer_trx_lines.interface_line_attribute5%type,
19: p_interface_line_attribute6 IN
20: ra_customer_trx_lines.interface_line_attribute6%type,
14: ra_customer_trx_lines.interface_line_attribute3%type,
15: p_interface_line_attribute4 IN
16: ra_customer_trx_lines.interface_line_attribute4%type,
17: p_interface_line_attribute5 IN
18: ra_customer_trx_lines.interface_line_attribute5%type,
19: p_interface_line_attribute6 IN
20: ra_customer_trx_lines.interface_line_attribute6%type,
21: p_interface_line_attribute7 IN
22: ra_customer_trx_lines.interface_line_attribute7%type,
16: ra_customer_trx_lines.interface_line_attribute4%type,
17: p_interface_line_attribute5 IN
18: ra_customer_trx_lines.interface_line_attribute5%type,
19: p_interface_line_attribute6 IN
20: ra_customer_trx_lines.interface_line_attribute6%type,
21: p_interface_line_attribute7 IN
22: ra_customer_trx_lines.interface_line_attribute7%type,
23: p_interface_line_attribute8 IN
24: ra_customer_trx_lines.interface_line_attribute8%type,
18: ra_customer_trx_lines.interface_line_attribute5%type,
19: p_interface_line_attribute6 IN
20: ra_customer_trx_lines.interface_line_attribute6%type,
21: p_interface_line_attribute7 IN
22: ra_customer_trx_lines.interface_line_attribute7%type,
23: p_interface_line_attribute8 IN
24: ra_customer_trx_lines.interface_line_attribute8%type,
25: p_interface_line_attribute9 IN
26: ra_customer_trx_lines.interface_line_attribute9%type,
20: ra_customer_trx_lines.interface_line_attribute6%type,
21: p_interface_line_attribute7 IN
22: ra_customer_trx_lines.interface_line_attribute7%type,
23: p_interface_line_attribute8 IN
24: ra_customer_trx_lines.interface_line_attribute8%type,
25: p_interface_line_attribute9 IN
26: ra_customer_trx_lines.interface_line_attribute9%type,
27: p_interface_line_attribute10 IN
28: ra_customer_trx_lines.interface_line_attribute10%type,
22: ra_customer_trx_lines.interface_line_attribute7%type,
23: p_interface_line_attribute8 IN
24: ra_customer_trx_lines.interface_line_attribute8%type,
25: p_interface_line_attribute9 IN
26: ra_customer_trx_lines.interface_line_attribute9%type,
27: p_interface_line_attribute10 IN
28: ra_customer_trx_lines.interface_line_attribute10%type,
29: p_interface_line_attribute11 IN
30: ra_customer_trx_lines.interface_line_attribute11%type,
24: ra_customer_trx_lines.interface_line_attribute8%type,
25: p_interface_line_attribute9 IN
26: ra_customer_trx_lines.interface_line_attribute9%type,
27: p_interface_line_attribute10 IN
28: ra_customer_trx_lines.interface_line_attribute10%type,
29: p_interface_line_attribute11 IN
30: ra_customer_trx_lines.interface_line_attribute11%type,
31: p_interface_line_attribute12 IN
32: ra_customer_trx_lines.interface_line_attribute12%type,
26: ra_customer_trx_lines.interface_line_attribute9%type,
27: p_interface_line_attribute10 IN
28: ra_customer_trx_lines.interface_line_attribute10%type,
29: p_interface_line_attribute11 IN
30: ra_customer_trx_lines.interface_line_attribute11%type,
31: p_interface_line_attribute12 IN
32: ra_customer_trx_lines.interface_line_attribute12%type,
33: p_interface_line_attribute13 IN
34: ra_customer_trx_lines.interface_line_attribute13%type,
28: ra_customer_trx_lines.interface_line_attribute10%type,
29: p_interface_line_attribute11 IN
30: ra_customer_trx_lines.interface_line_attribute11%type,
31: p_interface_line_attribute12 IN
32: ra_customer_trx_lines.interface_line_attribute12%type,
33: p_interface_line_attribute13 IN
34: ra_customer_trx_lines.interface_line_attribute13%type,
35: p_interface_line_attribute14 IN
36: ra_customer_trx_lines.interface_line_attribute14%type,
30: ra_customer_trx_lines.interface_line_attribute11%type,
31: p_interface_line_attribute12 IN
32: ra_customer_trx_lines.interface_line_attribute12%type,
33: p_interface_line_attribute13 IN
34: ra_customer_trx_lines.interface_line_attribute13%type,
35: p_interface_line_attribute14 IN
36: ra_customer_trx_lines.interface_line_attribute14%type,
37: p_interface_line_attribute15 IN
38: ra_customer_trx_lines.interface_line_attribute15%type)
32: ra_customer_trx_lines.interface_line_attribute12%type,
33: p_interface_line_attribute13 IN
34: ra_customer_trx_lines.interface_line_attribute13%type,
35: p_interface_line_attribute14 IN
36: ra_customer_trx_lines.interface_line_attribute14%type,
37: p_interface_line_attribute15 IN
38: ra_customer_trx_lines.interface_line_attribute15%type)
39: RETURN boolean;
40:
34: ra_customer_trx_lines.interface_line_attribute13%type,
35: p_interface_line_attribute14 IN
36: ra_customer_trx_lines.interface_line_attribute14%type,
37: p_interface_line_attribute15 IN
38: ra_customer_trx_lines.interface_line_attribute15%type)
39: RETURN boolean;
40:
41:
42: FUNCTION unique_trans_flex(
40:
41:
42: FUNCTION unique_trans_flex(
43: p_ctl_id IN
44: ra_customer_trx_lines.customer_trx_line_id%type,
45: p_interface_line_context IN
46: ra_customer_trx_lines.interface_line_context%type,
47: p_interface_line_attribute1 IN
48: ra_customer_trx_lines.interface_line_attribute1%type,
42: FUNCTION unique_trans_flex(
43: p_ctl_id IN
44: ra_customer_trx_lines.customer_trx_line_id%type,
45: p_interface_line_context IN
46: ra_customer_trx_lines.interface_line_context%type,
47: p_interface_line_attribute1 IN
48: ra_customer_trx_lines.interface_line_attribute1%type,
49: p_interface_line_attribute2 IN
50: ra_customer_trx_lines.interface_line_attribute2%type,
44: ra_customer_trx_lines.customer_trx_line_id%type,
45: p_interface_line_context IN
46: ra_customer_trx_lines.interface_line_context%type,
47: p_interface_line_attribute1 IN
48: ra_customer_trx_lines.interface_line_attribute1%type,
49: p_interface_line_attribute2 IN
50: ra_customer_trx_lines.interface_line_attribute2%type,
51: p_interface_line_attribute3 IN
52: ra_customer_trx_lines.interface_line_attribute3%type,
46: ra_customer_trx_lines.interface_line_context%type,
47: p_interface_line_attribute1 IN
48: ra_customer_trx_lines.interface_line_attribute1%type,
49: p_interface_line_attribute2 IN
50: ra_customer_trx_lines.interface_line_attribute2%type,
51: p_interface_line_attribute3 IN
52: ra_customer_trx_lines.interface_line_attribute3%type,
53: p_interface_line_attribute4 IN
54: ra_customer_trx_lines.interface_line_attribute4%type,
48: ra_customer_trx_lines.interface_line_attribute1%type,
49: p_interface_line_attribute2 IN
50: ra_customer_trx_lines.interface_line_attribute2%type,
51: p_interface_line_attribute3 IN
52: ra_customer_trx_lines.interface_line_attribute3%type,
53: p_interface_line_attribute4 IN
54: ra_customer_trx_lines.interface_line_attribute4%type,
55: p_interface_line_attribute5 IN
56: ra_customer_trx_lines.interface_line_attribute5%type,
50: ra_customer_trx_lines.interface_line_attribute2%type,
51: p_interface_line_attribute3 IN
52: ra_customer_trx_lines.interface_line_attribute3%type,
53: p_interface_line_attribute4 IN
54: ra_customer_trx_lines.interface_line_attribute4%type,
55: p_interface_line_attribute5 IN
56: ra_customer_trx_lines.interface_line_attribute5%type,
57: p_interface_line_attribute6 IN
58: ra_customer_trx_lines.interface_line_attribute6%type,
52: ra_customer_trx_lines.interface_line_attribute3%type,
53: p_interface_line_attribute4 IN
54: ra_customer_trx_lines.interface_line_attribute4%type,
55: p_interface_line_attribute5 IN
56: ra_customer_trx_lines.interface_line_attribute5%type,
57: p_interface_line_attribute6 IN
58: ra_customer_trx_lines.interface_line_attribute6%type,
59: p_interface_line_attribute7 IN
60: ra_customer_trx_lines.interface_line_attribute7%type,
54: ra_customer_trx_lines.interface_line_attribute4%type,
55: p_interface_line_attribute5 IN
56: ra_customer_trx_lines.interface_line_attribute5%type,
57: p_interface_line_attribute6 IN
58: ra_customer_trx_lines.interface_line_attribute6%type,
59: p_interface_line_attribute7 IN
60: ra_customer_trx_lines.interface_line_attribute7%type,
61: p_interface_line_attribute8 IN
62: ra_customer_trx_lines.interface_line_attribute8%type,
56: ra_customer_trx_lines.interface_line_attribute5%type,
57: p_interface_line_attribute6 IN
58: ra_customer_trx_lines.interface_line_attribute6%type,
59: p_interface_line_attribute7 IN
60: ra_customer_trx_lines.interface_line_attribute7%type,
61: p_interface_line_attribute8 IN
62: ra_customer_trx_lines.interface_line_attribute8%type,
63: p_interface_line_attribute9 IN
64: ra_customer_trx_lines.interface_line_attribute9%type,
58: ra_customer_trx_lines.interface_line_attribute6%type,
59: p_interface_line_attribute7 IN
60: ra_customer_trx_lines.interface_line_attribute7%type,
61: p_interface_line_attribute8 IN
62: ra_customer_trx_lines.interface_line_attribute8%type,
63: p_interface_line_attribute9 IN
64: ra_customer_trx_lines.interface_line_attribute9%type,
65: p_interface_line_attribute10 IN
66: ra_customer_trx_lines.interface_line_attribute10%type,
60: ra_customer_trx_lines.interface_line_attribute7%type,
61: p_interface_line_attribute8 IN
62: ra_customer_trx_lines.interface_line_attribute8%type,
63: p_interface_line_attribute9 IN
64: ra_customer_trx_lines.interface_line_attribute9%type,
65: p_interface_line_attribute10 IN
66: ra_customer_trx_lines.interface_line_attribute10%type,
67: p_interface_line_attribute11 IN
68: ra_customer_trx_lines.interface_line_attribute11%type,
62: ra_customer_trx_lines.interface_line_attribute8%type,
63: p_interface_line_attribute9 IN
64: ra_customer_trx_lines.interface_line_attribute9%type,
65: p_interface_line_attribute10 IN
66: ra_customer_trx_lines.interface_line_attribute10%type,
67: p_interface_line_attribute11 IN
68: ra_customer_trx_lines.interface_line_attribute11%type,
69: p_interface_line_attribute12 IN
70: ra_customer_trx_lines.interface_line_attribute12%type,
64: ra_customer_trx_lines.interface_line_attribute9%type,
65: p_interface_line_attribute10 IN
66: ra_customer_trx_lines.interface_line_attribute10%type,
67: p_interface_line_attribute11 IN
68: ra_customer_trx_lines.interface_line_attribute11%type,
69: p_interface_line_attribute12 IN
70: ra_customer_trx_lines.interface_line_attribute12%type,
71: p_interface_line_attribute13 IN
72: ra_customer_trx_lines.interface_line_attribute13%type,
66: ra_customer_trx_lines.interface_line_attribute10%type,
67: p_interface_line_attribute11 IN
68: ra_customer_trx_lines.interface_line_attribute11%type,
69: p_interface_line_attribute12 IN
70: ra_customer_trx_lines.interface_line_attribute12%type,
71: p_interface_line_attribute13 IN
72: ra_customer_trx_lines.interface_line_attribute13%type,
73: p_interface_line_attribute14 IN
74: ra_customer_trx_lines.interface_line_attribute14%type,
68: ra_customer_trx_lines.interface_line_attribute11%type,
69: p_interface_line_attribute12 IN
70: ra_customer_trx_lines.interface_line_attribute12%type,
71: p_interface_line_attribute13 IN
72: ra_customer_trx_lines.interface_line_attribute13%type,
73: p_interface_line_attribute14 IN
74: ra_customer_trx_lines.interface_line_attribute14%type,
75: p_interface_line_attribute15 IN
76: ra_customer_trx_lines.interface_line_attribute15%type,
70: ra_customer_trx_lines.interface_line_attribute12%type,
71: p_interface_line_attribute13 IN
72: ra_customer_trx_lines.interface_line_attribute13%type,
73: p_interface_line_attribute14 IN
74: ra_customer_trx_lines.interface_line_attribute14%type,
75: p_interface_line_attribute15 IN
76: ra_customer_trx_lines.interface_line_attribute15%type,
77: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
78: p_customer_trx_line_id OUT NOCOPY
72: ra_customer_trx_lines.interface_line_attribute13%type,
73: p_interface_line_attribute14 IN
74: ra_customer_trx_lines.interface_line_attribute14%type,
75: p_interface_line_attribute15 IN
76: ra_customer_trx_lines.interface_line_attribute15%type,
77: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
78: p_customer_trx_line_id OUT NOCOPY
79: ra_customer_trx_lines.customer_trx_line_id%type)
80: RETURN BOOLEAN;
73: p_interface_line_attribute14 IN
74: ra_customer_trx_lines.interface_line_attribute14%type,
75: p_interface_line_attribute15 IN
76: ra_customer_trx_lines.interface_line_attribute15%type,
77: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
78: p_customer_trx_line_id OUT NOCOPY
79: ra_customer_trx_lines.customer_trx_line_id%type)
80: RETURN BOOLEAN;
81:
75: p_interface_line_attribute15 IN
76: ra_customer_trx_lines.interface_line_attribute15%type,
77: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
78: p_customer_trx_line_id OUT NOCOPY
79: ra_customer_trx_lines.customer_trx_line_id%type)
80: RETURN BOOLEAN;
81:
82: PROCEDURE print_cache_contents;
83: