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,
24: credited_salesrep_id cn_posting_details.credited_salesrep_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,
26: quota_rule_id cn_posting_details.quota_rule_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
42: := FND_API.G_MISS_NUM,
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
44: := FND_API.G_MISS_CHAR,
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
46: := FND_API.G_MISS_CHAR,
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
48: := FND_API.G_MISS_CHAR,
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
50: := FND_API.G_MISS_CHAR,
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
52: := FND_API.G_MISS_CHAR,
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
54: := FND_API.G_MISS_CHAR,
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
56: := FND_API.G_MISS_CHAR,
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
58: := FND_API.G_MISS_CHAR,
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
60: := FND_API.G_MISS_CHAR,
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
62: := FND_API.G_MISS_CHAR,
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
64: := FND_API.G_MISS_CHAR,
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
66: := FND_API.G_MISS_CHAR,
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
68: := FND_API.G_MISS_CHAR,
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
70: := FND_API.G_MISS_CHAR,
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
72: := FND_API.G_MISS_CHAR,
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
74: := FND_API.G_MISS_CHAR,
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,
76: creation_date cn_posting_details.creation_date%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,
78: last_update_date cn_posting_details.last_update_date%TYPE,