1: PACKAGE CN_PREPOSTDETAILS AUTHID CURRENT_USER AS
2: -- $Header: cntpdets.pls 115.7 2002/01/28 20:05:03 pkm ship $ --+
3:
4: TYPE posting_detail_rec_type IS RECORD
5: (posting_detail_id cn_posting_details.posting_detail_id%TYPE,
6: posting_batch_id cn_posting_details.posting_batch_id%TYPE,
7: posting_type cn_posting_details.posting_type%TYPE,
8: trx_type cn_posting_details.trx_type%TYPE,
9: payee_salesrep_id cn_posting_details.payee_salesrep_id%TYPE,
2: -- $Header: cntpdets.pls 115.7 2002/01/28 20:05:03 pkm ship $ --+
3:
4: TYPE posting_detail_rec_type IS RECORD
5: (posting_detail_id cn_posting_details.posting_detail_id%TYPE,
6: posting_batch_id cn_posting_details.posting_batch_id%TYPE,
7: posting_type cn_posting_details.posting_type%TYPE,
8: trx_type cn_posting_details.trx_type%TYPE,
9: payee_salesrep_id cn_posting_details.payee_salesrep_id%TYPE,
10: role_id cn_posting_details.role_id%TYPE,
3:
4: TYPE posting_detail_rec_type IS RECORD
5: (posting_detail_id cn_posting_details.posting_detail_id%TYPE,
6: posting_batch_id cn_posting_details.posting_batch_id%TYPE,
7: posting_type cn_posting_details.posting_type%TYPE,
8: trx_type cn_posting_details.trx_type%TYPE,
9: payee_salesrep_id cn_posting_details.payee_salesrep_id%TYPE,
10: role_id cn_posting_details.role_id%TYPE,
11: incentive_type_code cn_posting_details.incentive_type_code%TYPE,
4: TYPE posting_detail_rec_type IS RECORD
5: (posting_detail_id cn_posting_details.posting_detail_id%TYPE,
6: posting_batch_id cn_posting_details.posting_batch_id%TYPE,
7: posting_type cn_posting_details.posting_type%TYPE,
8: trx_type cn_posting_details.trx_type%TYPE,
9: payee_salesrep_id cn_posting_details.payee_salesrep_id%TYPE,
10: role_id cn_posting_details.role_id%TYPE,
11: incentive_type_code cn_posting_details.incentive_type_code%TYPE,
12: credit_type_id cn_posting_details.credit_type_id%TYPE,
5: (posting_detail_id cn_posting_details.posting_detail_id%TYPE,
6: posting_batch_id cn_posting_details.posting_batch_id%TYPE,
7: posting_type cn_posting_details.posting_type%TYPE,
8: trx_type cn_posting_details.trx_type%TYPE,
9: payee_salesrep_id cn_posting_details.payee_salesrep_id%TYPE,
10: role_id cn_posting_details.role_id%TYPE,
11: incentive_type_code cn_posting_details.incentive_type_code%TYPE,
12: credit_type_id cn_posting_details.credit_type_id%TYPE,
13: pay_period_id cn_posting_details.pay_period_id%TYPE,
6: posting_batch_id cn_posting_details.posting_batch_id%TYPE,
7: posting_type cn_posting_details.posting_type%TYPE,
8: trx_type cn_posting_details.trx_type%TYPE,
9: payee_salesrep_id cn_posting_details.payee_salesrep_id%TYPE,
10: role_id cn_posting_details.role_id%TYPE,
11: incentive_type_code cn_posting_details.incentive_type_code%TYPE,
12: credit_type_id cn_posting_details.credit_type_id%TYPE,
13: pay_period_id cn_posting_details.pay_period_id%TYPE,
14: amount cn_posting_details.amount%TYPE := 0,
7: posting_type cn_posting_details.posting_type%TYPE,
8: trx_type cn_posting_details.trx_type%TYPE,
9: payee_salesrep_id cn_posting_details.payee_salesrep_id%TYPE,
10: role_id cn_posting_details.role_id%TYPE,
11: incentive_type_code cn_posting_details.incentive_type_code%TYPE,
12: credit_type_id cn_posting_details.credit_type_id%TYPE,
13: pay_period_id cn_posting_details.pay_period_id%TYPE,
14: amount cn_posting_details.amount%TYPE := 0,
15: commission_header_id cn_posting_details.commission_header_id%TYPE,
8: trx_type cn_posting_details.trx_type%TYPE,
9: payee_salesrep_id cn_posting_details.payee_salesrep_id%TYPE,
10: role_id cn_posting_details.role_id%TYPE,
11: incentive_type_code cn_posting_details.incentive_type_code%TYPE,
12: credit_type_id cn_posting_details.credit_type_id%TYPE,
13: pay_period_id cn_posting_details.pay_period_id%TYPE,
14: amount cn_posting_details.amount%TYPE := 0,
15: commission_header_id cn_posting_details.commission_header_id%TYPE,
16: commission_line_id cn_posting_details.commission_line_id%TYPE,
9: payee_salesrep_id cn_posting_details.payee_salesrep_id%TYPE,
10: role_id cn_posting_details.role_id%TYPE,
11: incentive_type_code cn_posting_details.incentive_type_code%TYPE,
12: credit_type_id cn_posting_details.credit_type_id%TYPE,
13: pay_period_id cn_posting_details.pay_period_id%TYPE,
14: amount cn_posting_details.amount%TYPE := 0,
15: commission_header_id cn_posting_details.commission_header_id%TYPE,
16: commission_line_id cn_posting_details.commission_line_id%TYPE,
17: srp_plan_assign_id cn_posting_details.srp_plan_assign_id%TYPE,
10: role_id cn_posting_details.role_id%TYPE,
11: incentive_type_code cn_posting_details.incentive_type_code%TYPE,
12: credit_type_id cn_posting_details.credit_type_id%TYPE,
13: pay_period_id cn_posting_details.pay_period_id%TYPE,
14: amount cn_posting_details.amount%TYPE := 0,
15: commission_header_id cn_posting_details.commission_header_id%TYPE,
16: commission_line_id cn_posting_details.commission_line_id%TYPE,
17: srp_plan_assign_id cn_posting_details.srp_plan_assign_id%TYPE,
18: quota_id cn_posting_details.quota_id%TYPE,
11: incentive_type_code cn_posting_details.incentive_type_code%TYPE,
12: credit_type_id cn_posting_details.credit_type_id%TYPE,
13: pay_period_id cn_posting_details.pay_period_id%TYPE,
14: amount cn_posting_details.amount%TYPE := 0,
15: commission_header_id cn_posting_details.commission_header_id%TYPE,
16: commission_line_id cn_posting_details.commission_line_id%TYPE,
17: srp_plan_assign_id cn_posting_details.srp_plan_assign_id%TYPE,
18: quota_id cn_posting_details.quota_id%TYPE,
19: status cn_posting_details.status%TYPE
12: credit_type_id cn_posting_details.credit_type_id%TYPE,
13: pay_period_id cn_posting_details.pay_period_id%TYPE,
14: amount cn_posting_details.amount%TYPE := 0,
15: commission_header_id cn_posting_details.commission_header_id%TYPE,
16: commission_line_id cn_posting_details.commission_line_id%TYPE,
17: srp_plan_assign_id cn_posting_details.srp_plan_assign_id%TYPE,
18: quota_id cn_posting_details.quota_id%TYPE,
19: status cn_posting_details.status%TYPE
20: := FND_API.G_MISS_CHAR,
13: pay_period_id cn_posting_details.pay_period_id%TYPE,
14: amount cn_posting_details.amount%TYPE := 0,
15: commission_header_id cn_posting_details.commission_header_id%TYPE,
16: commission_line_id cn_posting_details.commission_line_id%TYPE,
17: srp_plan_assign_id cn_posting_details.srp_plan_assign_id%TYPE,
18: quota_id cn_posting_details.quota_id%TYPE,
19: status cn_posting_details.status%TYPE
20: := FND_API.G_MISS_CHAR,
21: loaded_date cn_posting_details.loaded_date%TYPE
14: amount cn_posting_details.amount%TYPE := 0,
15: commission_header_id cn_posting_details.commission_header_id%TYPE,
16: commission_line_id cn_posting_details.commission_line_id%TYPE,
17: srp_plan_assign_id cn_posting_details.srp_plan_assign_id%TYPE,
18: quota_id cn_posting_details.quota_id%TYPE,
19: status cn_posting_details.status%TYPE
20: := FND_API.G_MISS_CHAR,
21: loaded_date cn_posting_details.loaded_date%TYPE
22: := FND_API.G_MISS_DATE,
15: commission_header_id cn_posting_details.commission_header_id%TYPE,
16: commission_line_id cn_posting_details.commission_line_id%TYPE,
17: srp_plan_assign_id cn_posting_details.srp_plan_assign_id%TYPE,
18: quota_id cn_posting_details.quota_id%TYPE,
19: status cn_posting_details.status%TYPE
20: := FND_API.G_MISS_CHAR,
21: loaded_date cn_posting_details.loaded_date%TYPE
22: := FND_API.G_MISS_DATE,
23: processed_date cn_posting_details.processed_date%TYPE,
17: srp_plan_assign_id cn_posting_details.srp_plan_assign_id%TYPE,
18: quota_id cn_posting_details.quota_id%TYPE,
19: status cn_posting_details.status%TYPE
20: := FND_API.G_MISS_CHAR,
21: loaded_date cn_posting_details.loaded_date%TYPE
22: := FND_API.G_MISS_DATE,
23: processed_date cn_posting_details.processed_date%TYPE,
24: credited_salesrep_id cn_posting_details.credited_salesrep_id%TYPE,
25: processed_period_id cn_posting_details.processed_period_id%TYPE,
19: status cn_posting_details.status%TYPE
20: := FND_API.G_MISS_CHAR,
21: loaded_date cn_posting_details.loaded_date%TYPE
22: := FND_API.G_MISS_DATE,
23: processed_date cn_posting_details.processed_date%TYPE,
24: credited_salesrep_id cn_posting_details.credited_salesrep_id%TYPE,
25: processed_period_id cn_posting_details.processed_period_id%TYPE,
26: quota_rule_id cn_posting_details.quota_rule_id%TYPE,
27: event_factor cn_posting_details.event_factor%TYPE,
20: := FND_API.G_MISS_CHAR,
21: loaded_date cn_posting_details.loaded_date%TYPE
22: := FND_API.G_MISS_DATE,
23: processed_date cn_posting_details.processed_date%TYPE,
24: credited_salesrep_id cn_posting_details.credited_salesrep_id%TYPE,
25: processed_period_id cn_posting_details.processed_period_id%TYPE,
26: quota_rule_id cn_posting_details.quota_rule_id%TYPE,
27: event_factor cn_posting_details.event_factor%TYPE,
28: payment_factor cn_posting_details.payment_factor%TYPE,
21: loaded_date cn_posting_details.loaded_date%TYPE
22: := FND_API.G_MISS_DATE,
23: processed_date cn_posting_details.processed_date%TYPE,
24: credited_salesrep_id cn_posting_details.credited_salesrep_id%TYPE,
25: processed_period_id cn_posting_details.processed_period_id%TYPE,
26: quota_rule_id cn_posting_details.quota_rule_id%TYPE,
27: event_factor cn_posting_details.event_factor%TYPE,
28: payment_factor cn_posting_details.payment_factor%TYPE,
29: quota_factor cn_posting_details.quota_factor%TYPE,
22: := FND_API.G_MISS_DATE,
23: processed_date cn_posting_details.processed_date%TYPE,
24: credited_salesrep_id cn_posting_details.credited_salesrep_id%TYPE,
25: processed_period_id cn_posting_details.processed_period_id%TYPE,
26: quota_rule_id cn_posting_details.quota_rule_id%TYPE,
27: event_factor cn_posting_details.event_factor%TYPE,
28: payment_factor cn_posting_details.payment_factor%TYPE,
29: quota_factor cn_posting_details.quota_factor%TYPE,
30: pending_status cn_posting_details.pending_status%TYPE,
23: processed_date cn_posting_details.processed_date%TYPE,
24: credited_salesrep_id cn_posting_details.credited_salesrep_id%TYPE,
25: processed_period_id cn_posting_details.processed_period_id%TYPE,
26: quota_rule_id cn_posting_details.quota_rule_id%TYPE,
27: event_factor cn_posting_details.event_factor%TYPE,
28: payment_factor cn_posting_details.payment_factor%TYPE,
29: quota_factor cn_posting_details.quota_factor%TYPE,
30: pending_status cn_posting_details.pending_status%TYPE,
31: input_achieved cn_posting_details.input_achieved%TYPE,
24: credited_salesrep_id cn_posting_details.credited_salesrep_id%TYPE,
25: processed_period_id cn_posting_details.processed_period_id%TYPE,
26: quota_rule_id cn_posting_details.quota_rule_id%TYPE,
27: event_factor cn_posting_details.event_factor%TYPE,
28: payment_factor cn_posting_details.payment_factor%TYPE,
29: quota_factor cn_posting_details.quota_factor%TYPE,
30: pending_status cn_posting_details.pending_status%TYPE,
31: input_achieved cn_posting_details.input_achieved%TYPE,
32: rate_tier_id cn_posting_details.rate_tier_id%TYPE,
25: processed_period_id cn_posting_details.processed_period_id%TYPE,
26: quota_rule_id cn_posting_details.quota_rule_id%TYPE,
27: event_factor cn_posting_details.event_factor%TYPE,
28: payment_factor cn_posting_details.payment_factor%TYPE,
29: quota_factor cn_posting_details.quota_factor%TYPE,
30: pending_status cn_posting_details.pending_status%TYPE,
31: input_achieved cn_posting_details.input_achieved%TYPE,
32: rate_tier_id cn_posting_details.rate_tier_id%TYPE,
33: payee_line_id cn_posting_details.payee_line_id%TYPE,
26: quota_rule_id cn_posting_details.quota_rule_id%TYPE,
27: event_factor cn_posting_details.event_factor%TYPE,
28: payment_factor cn_posting_details.payment_factor%TYPE,
29: quota_factor cn_posting_details.quota_factor%TYPE,
30: pending_status cn_posting_details.pending_status%TYPE,
31: input_achieved cn_posting_details.input_achieved%TYPE,
32: rate_tier_id cn_posting_details.rate_tier_id%TYPE,
33: payee_line_id cn_posting_details.payee_line_id%TYPE,
34: cl_status cn_posting_details.cl_status%TYPE,
27: event_factor cn_posting_details.event_factor%TYPE,
28: payment_factor cn_posting_details.payment_factor%TYPE,
29: quota_factor cn_posting_details.quota_factor%TYPE,
30: pending_status cn_posting_details.pending_status%TYPE,
31: input_achieved cn_posting_details.input_achieved%TYPE,
32: rate_tier_id cn_posting_details.rate_tier_id%TYPE,
33: payee_line_id cn_posting_details.payee_line_id%TYPE,
34: cl_status cn_posting_details.cl_status%TYPE,
35: created_during cn_posting_details.created_during%TYPE,
28: payment_factor cn_posting_details.payment_factor%TYPE,
29: quota_factor cn_posting_details.quota_factor%TYPE,
30: pending_status cn_posting_details.pending_status%TYPE,
31: input_achieved cn_posting_details.input_achieved%TYPE,
32: rate_tier_id cn_posting_details.rate_tier_id%TYPE,
33: payee_line_id cn_posting_details.payee_line_id%TYPE,
34: cl_status cn_posting_details.cl_status%TYPE,
35: created_during cn_posting_details.created_during%TYPE,
36: commission_rate cn_posting_details.commission_rate%TYPE := 0,
29: quota_factor cn_posting_details.quota_factor%TYPE,
30: pending_status cn_posting_details.pending_status%TYPE,
31: input_achieved cn_posting_details.input_achieved%TYPE,
32: rate_tier_id cn_posting_details.rate_tier_id%TYPE,
33: payee_line_id cn_posting_details.payee_line_id%TYPE,
34: cl_status cn_posting_details.cl_status%TYPE,
35: created_during cn_posting_details.created_during%TYPE,
36: commission_rate cn_posting_details.commission_rate%TYPE := 0,
37: hold_flag cn_posting_details.hold_flag%TYPE
30: pending_status cn_posting_details.pending_status%TYPE,
31: input_achieved cn_posting_details.input_achieved%TYPE,
32: rate_tier_id cn_posting_details.rate_tier_id%TYPE,
33: payee_line_id cn_posting_details.payee_line_id%TYPE,
34: cl_status cn_posting_details.cl_status%TYPE,
35: created_during cn_posting_details.created_during%TYPE,
36: commission_rate cn_posting_details.commission_rate%TYPE := 0,
37: hold_flag cn_posting_details.hold_flag%TYPE
38: := FND_API.G_MISS_CHAR,
31: input_achieved cn_posting_details.input_achieved%TYPE,
32: rate_tier_id cn_posting_details.rate_tier_id%TYPE,
33: payee_line_id cn_posting_details.payee_line_id%TYPE,
34: cl_status cn_posting_details.cl_status%TYPE,
35: created_during cn_posting_details.created_during%TYPE,
36: commission_rate cn_posting_details.commission_rate%TYPE := 0,
37: hold_flag cn_posting_details.hold_flag%TYPE
38: := FND_API.G_MISS_CHAR,
39: paid_flag cn_posting_details.paid_flag%TYPE
32: rate_tier_id cn_posting_details.rate_tier_id%TYPE,
33: payee_line_id cn_posting_details.payee_line_id%TYPE,
34: cl_status cn_posting_details.cl_status%TYPE,
35: created_during cn_posting_details.created_during%TYPE,
36: commission_rate cn_posting_details.commission_rate%TYPE := 0,
37: hold_flag cn_posting_details.hold_flag%TYPE
38: := FND_API.G_MISS_CHAR,
39: paid_flag cn_posting_details.paid_flag%TYPE
40: := FND_API.G_MISS_CHAR,
33: payee_line_id cn_posting_details.payee_line_id%TYPE,
34: cl_status cn_posting_details.cl_status%TYPE,
35: created_during cn_posting_details.created_during%TYPE,
36: commission_rate cn_posting_details.commission_rate%TYPE := 0,
37: hold_flag cn_posting_details.hold_flag%TYPE
38: := FND_API.G_MISS_CHAR,
39: paid_flag cn_posting_details.paid_flag%TYPE
40: := FND_API.G_MISS_CHAR,
41: payment_amount cn_posting_details.payment_amount%TYPE
35: created_during cn_posting_details.created_during%TYPE,
36: commission_rate cn_posting_details.commission_rate%TYPE := 0,
37: hold_flag cn_posting_details.hold_flag%TYPE
38: := FND_API.G_MISS_CHAR,
39: paid_flag cn_posting_details.paid_flag%TYPE
40: := FND_API.G_MISS_CHAR,
41: payment_amount cn_posting_details.payment_amount%TYPE
42: := FND_API.G_MISS_NUM,
43: attribute_category cn_posting_details.attribute_category%TYPE
37: hold_flag cn_posting_details.hold_flag%TYPE
38: := FND_API.G_MISS_CHAR,
39: paid_flag cn_posting_details.paid_flag%TYPE
40: := FND_API.G_MISS_CHAR,
41: payment_amount cn_posting_details.payment_amount%TYPE
42: := FND_API.G_MISS_NUM,
43: attribute_category cn_posting_details.attribute_category%TYPE
44: := FND_API.G_MISS_CHAR,
45: attribute1 cn_posting_details.attribute1%TYPE
39: paid_flag cn_posting_details.paid_flag%TYPE
40: := FND_API.G_MISS_CHAR,
41: payment_amount cn_posting_details.payment_amount%TYPE
42: := FND_API.G_MISS_NUM,
43: attribute_category cn_posting_details.attribute_category%TYPE
44: := FND_API.G_MISS_CHAR,
45: attribute1 cn_posting_details.attribute1%TYPE
46: := FND_API.G_MISS_CHAR,
47: attribute2 cn_posting_details.attribute2%TYPE
41: payment_amount cn_posting_details.payment_amount%TYPE
42: := FND_API.G_MISS_NUM,
43: attribute_category cn_posting_details.attribute_category%TYPE
44: := FND_API.G_MISS_CHAR,
45: attribute1 cn_posting_details.attribute1%TYPE
46: := FND_API.G_MISS_CHAR,
47: attribute2 cn_posting_details.attribute2%TYPE
48: := FND_API.G_MISS_CHAR,
49: attribute3 cn_posting_details.attribute3%TYPE
43: attribute_category cn_posting_details.attribute_category%TYPE
44: := FND_API.G_MISS_CHAR,
45: attribute1 cn_posting_details.attribute1%TYPE
46: := FND_API.G_MISS_CHAR,
47: attribute2 cn_posting_details.attribute2%TYPE
48: := FND_API.G_MISS_CHAR,
49: attribute3 cn_posting_details.attribute3%TYPE
50: := FND_API.G_MISS_CHAR,
51: attribute4 cn_posting_details.attribute4%TYPE
45: attribute1 cn_posting_details.attribute1%TYPE
46: := FND_API.G_MISS_CHAR,
47: attribute2 cn_posting_details.attribute2%TYPE
48: := FND_API.G_MISS_CHAR,
49: attribute3 cn_posting_details.attribute3%TYPE
50: := FND_API.G_MISS_CHAR,
51: attribute4 cn_posting_details.attribute4%TYPE
52: := FND_API.G_MISS_CHAR,
53: attribute5 cn_posting_details.attribute5%TYPE
47: attribute2 cn_posting_details.attribute2%TYPE
48: := FND_API.G_MISS_CHAR,
49: attribute3 cn_posting_details.attribute3%TYPE
50: := FND_API.G_MISS_CHAR,
51: attribute4 cn_posting_details.attribute4%TYPE
52: := FND_API.G_MISS_CHAR,
53: attribute5 cn_posting_details.attribute5%TYPE
54: := FND_API.G_MISS_CHAR,
55: attribute6 cn_posting_details.attribute6%TYPE
49: attribute3 cn_posting_details.attribute3%TYPE
50: := FND_API.G_MISS_CHAR,
51: attribute4 cn_posting_details.attribute4%TYPE
52: := FND_API.G_MISS_CHAR,
53: attribute5 cn_posting_details.attribute5%TYPE
54: := FND_API.G_MISS_CHAR,
55: attribute6 cn_posting_details.attribute6%TYPE
56: := FND_API.G_MISS_CHAR,
57: attribute7 cn_posting_details.attribute7%TYPE
51: attribute4 cn_posting_details.attribute4%TYPE
52: := FND_API.G_MISS_CHAR,
53: attribute5 cn_posting_details.attribute5%TYPE
54: := FND_API.G_MISS_CHAR,
55: attribute6 cn_posting_details.attribute6%TYPE
56: := FND_API.G_MISS_CHAR,
57: attribute7 cn_posting_details.attribute7%TYPE
58: := FND_API.G_MISS_CHAR,
59: attribute8 cn_posting_details.attribute8%TYPE
53: attribute5 cn_posting_details.attribute5%TYPE
54: := FND_API.G_MISS_CHAR,
55: attribute6 cn_posting_details.attribute6%TYPE
56: := FND_API.G_MISS_CHAR,
57: attribute7 cn_posting_details.attribute7%TYPE
58: := FND_API.G_MISS_CHAR,
59: attribute8 cn_posting_details.attribute8%TYPE
60: := FND_API.G_MISS_CHAR,
61: attribute9 cn_posting_details.attribute9%TYPE
55: attribute6 cn_posting_details.attribute6%TYPE
56: := FND_API.G_MISS_CHAR,
57: attribute7 cn_posting_details.attribute7%TYPE
58: := FND_API.G_MISS_CHAR,
59: attribute8 cn_posting_details.attribute8%TYPE
60: := FND_API.G_MISS_CHAR,
61: attribute9 cn_posting_details.attribute9%TYPE
62: := FND_API.G_MISS_CHAR,
63: attribute10 cn_posting_details.attribute10%TYPE
57: attribute7 cn_posting_details.attribute7%TYPE
58: := FND_API.G_MISS_CHAR,
59: attribute8 cn_posting_details.attribute8%TYPE
60: := FND_API.G_MISS_CHAR,
61: attribute9 cn_posting_details.attribute9%TYPE
62: := FND_API.G_MISS_CHAR,
63: attribute10 cn_posting_details.attribute10%TYPE
64: := FND_API.G_MISS_CHAR,
65: attribute11 cn_posting_details.attribute11%TYPE
59: attribute8 cn_posting_details.attribute8%TYPE
60: := FND_API.G_MISS_CHAR,
61: attribute9 cn_posting_details.attribute9%TYPE
62: := FND_API.G_MISS_CHAR,
63: attribute10 cn_posting_details.attribute10%TYPE
64: := FND_API.G_MISS_CHAR,
65: attribute11 cn_posting_details.attribute11%TYPE
66: := FND_API.G_MISS_CHAR,
67: attribute12 cn_posting_details.attribute12%TYPE
61: attribute9 cn_posting_details.attribute9%TYPE
62: := FND_API.G_MISS_CHAR,
63: attribute10 cn_posting_details.attribute10%TYPE
64: := FND_API.G_MISS_CHAR,
65: attribute11 cn_posting_details.attribute11%TYPE
66: := FND_API.G_MISS_CHAR,
67: attribute12 cn_posting_details.attribute12%TYPE
68: := FND_API.G_MISS_CHAR,
69: attribute13 cn_posting_details.attribute13%TYPE
63: attribute10 cn_posting_details.attribute10%TYPE
64: := FND_API.G_MISS_CHAR,
65: attribute11 cn_posting_details.attribute11%TYPE
66: := FND_API.G_MISS_CHAR,
67: attribute12 cn_posting_details.attribute12%TYPE
68: := FND_API.G_MISS_CHAR,
69: attribute13 cn_posting_details.attribute13%TYPE
70: := FND_API.G_MISS_CHAR,
71: attribute14 cn_posting_details.attribute14%TYPE
65: attribute11 cn_posting_details.attribute11%TYPE
66: := FND_API.G_MISS_CHAR,
67: attribute12 cn_posting_details.attribute12%TYPE
68: := FND_API.G_MISS_CHAR,
69: attribute13 cn_posting_details.attribute13%TYPE
70: := FND_API.G_MISS_CHAR,
71: attribute14 cn_posting_details.attribute14%TYPE
72: := FND_API.G_MISS_CHAR,
73: attribute15 cn_posting_details.attribute15%TYPE
67: attribute12 cn_posting_details.attribute12%TYPE
68: := FND_API.G_MISS_CHAR,
69: attribute13 cn_posting_details.attribute13%TYPE
70: := FND_API.G_MISS_CHAR,
71: attribute14 cn_posting_details.attribute14%TYPE
72: := FND_API.G_MISS_CHAR,
73: attribute15 cn_posting_details.attribute15%TYPE
74: := FND_API.G_MISS_CHAR,
75: created_by cn_posting_details.created_by%TYPE,
69: attribute13 cn_posting_details.attribute13%TYPE
70: := FND_API.G_MISS_CHAR,
71: attribute14 cn_posting_details.attribute14%TYPE
72: := FND_API.G_MISS_CHAR,
73: attribute15 cn_posting_details.attribute15%TYPE
74: := FND_API.G_MISS_CHAR,
75: created_by cn_posting_details.created_by%TYPE,
76: creation_date cn_posting_details.creation_date%TYPE,
77: last_update_login cn_posting_details.last_update_login%TYPE,
71: attribute14 cn_posting_details.attribute14%TYPE
72: := FND_API.G_MISS_CHAR,
73: attribute15 cn_posting_details.attribute15%TYPE
74: := FND_API.G_MISS_CHAR,
75: created_by cn_posting_details.created_by%TYPE,
76: creation_date cn_posting_details.creation_date%TYPE,
77: last_update_login cn_posting_details.last_update_login%TYPE,
78: last_update_date cn_posting_details.last_update_date%TYPE,
79: last_updated_by cn_posting_details.last_updated_by%TYPE);
72: := FND_API.G_MISS_CHAR,
73: attribute15 cn_posting_details.attribute15%TYPE
74: := FND_API.G_MISS_CHAR,
75: created_by cn_posting_details.created_by%TYPE,
76: creation_date cn_posting_details.creation_date%TYPE,
77: last_update_login cn_posting_details.last_update_login%TYPE,
78: last_update_date cn_posting_details.last_update_date%TYPE,
79: last_updated_by cn_posting_details.last_updated_by%TYPE);
80:
73: attribute15 cn_posting_details.attribute15%TYPE
74: := FND_API.G_MISS_CHAR,
75: created_by cn_posting_details.created_by%TYPE,
76: creation_date cn_posting_details.creation_date%TYPE,
77: last_update_login cn_posting_details.last_update_login%TYPE,
78: last_update_date cn_posting_details.last_update_date%TYPE,
79: last_updated_by cn_posting_details.last_updated_by%TYPE);
80:
81: TYPE posting_detail_rec_tbl_type IS TABLE OF posting_detail_rec_type
74: := FND_API.G_MISS_CHAR,
75: created_by cn_posting_details.created_by%TYPE,
76: creation_date cn_posting_details.creation_date%TYPE,
77: last_update_login cn_posting_details.last_update_login%TYPE,
78: last_update_date cn_posting_details.last_update_date%TYPE,
79: last_updated_by cn_posting_details.last_updated_by%TYPE);
80:
81: TYPE posting_detail_rec_tbl_type IS TABLE OF posting_detail_rec_type
82: INDEX BY BINARY_INTEGER;
75: created_by cn_posting_details.created_by%TYPE,
76: creation_date cn_posting_details.creation_date%TYPE,
77: last_update_login cn_posting_details.last_update_login%TYPE,
78: last_update_date cn_posting_details.last_update_date%TYPE,
79: last_updated_by cn_posting_details.last_updated_by%TYPE);
80:
81: TYPE posting_detail_rec_tbl_type IS TABLE OF posting_detail_rec_type
82: INDEX BY BINARY_INTEGER;
83: