APPS.OKL_LAP_PVT dependencies on OKL_LEASE_APPLICATIONS_B

Line 34: id okl_lease_applications_b.id%TYPE

30: ------------------
31:
32: -- Do not include WHO columns in the base table record structure
33: TYPE lap_rec_type IS RECORD (
34: id okl_lease_applications_b.id%TYPE
35: ,object_version_number okl_lease_applications_b.object_version_number%TYPE
36: ,attribute_category okl_lease_applications_b.attribute_category%TYPE
37: ,attribute1 okl_lease_applications_b.attribute1%TYPE
38: ,attribute2 okl_lease_applications_b.attribute2%TYPE

Line 35: ,object_version_number okl_lease_applications_b.object_version_number%TYPE

31:
32: -- Do not include WHO columns in the base table record structure
33: TYPE lap_rec_type IS RECORD (
34: id okl_lease_applications_b.id%TYPE
35: ,object_version_number okl_lease_applications_b.object_version_number%TYPE
36: ,attribute_category okl_lease_applications_b.attribute_category%TYPE
37: ,attribute1 okl_lease_applications_b.attribute1%TYPE
38: ,attribute2 okl_lease_applications_b.attribute2%TYPE
39: ,attribute3 okl_lease_applications_b.attribute3%TYPE

Line 36: ,attribute_category okl_lease_applications_b.attribute_category%TYPE

32: -- Do not include WHO columns in the base table record structure
33: TYPE lap_rec_type IS RECORD (
34: id okl_lease_applications_b.id%TYPE
35: ,object_version_number okl_lease_applications_b.object_version_number%TYPE
36: ,attribute_category okl_lease_applications_b.attribute_category%TYPE
37: ,attribute1 okl_lease_applications_b.attribute1%TYPE
38: ,attribute2 okl_lease_applications_b.attribute2%TYPE
39: ,attribute3 okl_lease_applications_b.attribute3%TYPE
40: ,attribute4 okl_lease_applications_b.attribute4%TYPE

Line 37: ,attribute1 okl_lease_applications_b.attribute1%TYPE

33: TYPE lap_rec_type IS RECORD (
34: id okl_lease_applications_b.id%TYPE
35: ,object_version_number okl_lease_applications_b.object_version_number%TYPE
36: ,attribute_category okl_lease_applications_b.attribute_category%TYPE
37: ,attribute1 okl_lease_applications_b.attribute1%TYPE
38: ,attribute2 okl_lease_applications_b.attribute2%TYPE
39: ,attribute3 okl_lease_applications_b.attribute3%TYPE
40: ,attribute4 okl_lease_applications_b.attribute4%TYPE
41: ,attribute5 okl_lease_applications_b.attribute5%TYPE

Line 38: ,attribute2 okl_lease_applications_b.attribute2%TYPE

34: id okl_lease_applications_b.id%TYPE
35: ,object_version_number okl_lease_applications_b.object_version_number%TYPE
36: ,attribute_category okl_lease_applications_b.attribute_category%TYPE
37: ,attribute1 okl_lease_applications_b.attribute1%TYPE
38: ,attribute2 okl_lease_applications_b.attribute2%TYPE
39: ,attribute3 okl_lease_applications_b.attribute3%TYPE
40: ,attribute4 okl_lease_applications_b.attribute4%TYPE
41: ,attribute5 okl_lease_applications_b.attribute5%TYPE
42: ,attribute6 okl_lease_applications_b.attribute6%TYPE

Line 39: ,attribute3 okl_lease_applications_b.attribute3%TYPE

35: ,object_version_number okl_lease_applications_b.object_version_number%TYPE
36: ,attribute_category okl_lease_applications_b.attribute_category%TYPE
37: ,attribute1 okl_lease_applications_b.attribute1%TYPE
38: ,attribute2 okl_lease_applications_b.attribute2%TYPE
39: ,attribute3 okl_lease_applications_b.attribute3%TYPE
40: ,attribute4 okl_lease_applications_b.attribute4%TYPE
41: ,attribute5 okl_lease_applications_b.attribute5%TYPE
42: ,attribute6 okl_lease_applications_b.attribute6%TYPE
43: ,attribute7 okl_lease_applications_b.attribute7%TYPE

Line 40: ,attribute4 okl_lease_applications_b.attribute4%TYPE

36: ,attribute_category okl_lease_applications_b.attribute_category%TYPE
37: ,attribute1 okl_lease_applications_b.attribute1%TYPE
38: ,attribute2 okl_lease_applications_b.attribute2%TYPE
39: ,attribute3 okl_lease_applications_b.attribute3%TYPE
40: ,attribute4 okl_lease_applications_b.attribute4%TYPE
41: ,attribute5 okl_lease_applications_b.attribute5%TYPE
42: ,attribute6 okl_lease_applications_b.attribute6%TYPE
43: ,attribute7 okl_lease_applications_b.attribute7%TYPE
44: ,attribute8 okl_lease_applications_b.attribute8%TYPE

Line 41: ,attribute5 okl_lease_applications_b.attribute5%TYPE

37: ,attribute1 okl_lease_applications_b.attribute1%TYPE
38: ,attribute2 okl_lease_applications_b.attribute2%TYPE
39: ,attribute3 okl_lease_applications_b.attribute3%TYPE
40: ,attribute4 okl_lease_applications_b.attribute4%TYPE
41: ,attribute5 okl_lease_applications_b.attribute5%TYPE
42: ,attribute6 okl_lease_applications_b.attribute6%TYPE
43: ,attribute7 okl_lease_applications_b.attribute7%TYPE
44: ,attribute8 okl_lease_applications_b.attribute8%TYPE
45: ,attribute9 okl_lease_applications_b.attribute9%TYPE

Line 42: ,attribute6 okl_lease_applications_b.attribute6%TYPE

38: ,attribute2 okl_lease_applications_b.attribute2%TYPE
39: ,attribute3 okl_lease_applications_b.attribute3%TYPE
40: ,attribute4 okl_lease_applications_b.attribute4%TYPE
41: ,attribute5 okl_lease_applications_b.attribute5%TYPE
42: ,attribute6 okl_lease_applications_b.attribute6%TYPE
43: ,attribute7 okl_lease_applications_b.attribute7%TYPE
44: ,attribute8 okl_lease_applications_b.attribute8%TYPE
45: ,attribute9 okl_lease_applications_b.attribute9%TYPE
46: ,attribute10 okl_lease_applications_b.attribute10%TYPE

Line 43: ,attribute7 okl_lease_applications_b.attribute7%TYPE

39: ,attribute3 okl_lease_applications_b.attribute3%TYPE
40: ,attribute4 okl_lease_applications_b.attribute4%TYPE
41: ,attribute5 okl_lease_applications_b.attribute5%TYPE
42: ,attribute6 okl_lease_applications_b.attribute6%TYPE
43: ,attribute7 okl_lease_applications_b.attribute7%TYPE
44: ,attribute8 okl_lease_applications_b.attribute8%TYPE
45: ,attribute9 okl_lease_applications_b.attribute9%TYPE
46: ,attribute10 okl_lease_applications_b.attribute10%TYPE
47: ,attribute11 okl_lease_applications_b.attribute11%TYPE

Line 44: ,attribute8 okl_lease_applications_b.attribute8%TYPE

40: ,attribute4 okl_lease_applications_b.attribute4%TYPE
41: ,attribute5 okl_lease_applications_b.attribute5%TYPE
42: ,attribute6 okl_lease_applications_b.attribute6%TYPE
43: ,attribute7 okl_lease_applications_b.attribute7%TYPE
44: ,attribute8 okl_lease_applications_b.attribute8%TYPE
45: ,attribute9 okl_lease_applications_b.attribute9%TYPE
46: ,attribute10 okl_lease_applications_b.attribute10%TYPE
47: ,attribute11 okl_lease_applications_b.attribute11%TYPE
48: ,attribute12 okl_lease_applications_b.attribute12%TYPE

Line 45: ,attribute9 okl_lease_applications_b.attribute9%TYPE

41: ,attribute5 okl_lease_applications_b.attribute5%TYPE
42: ,attribute6 okl_lease_applications_b.attribute6%TYPE
43: ,attribute7 okl_lease_applications_b.attribute7%TYPE
44: ,attribute8 okl_lease_applications_b.attribute8%TYPE
45: ,attribute9 okl_lease_applications_b.attribute9%TYPE
46: ,attribute10 okl_lease_applications_b.attribute10%TYPE
47: ,attribute11 okl_lease_applications_b.attribute11%TYPE
48: ,attribute12 okl_lease_applications_b.attribute12%TYPE
49: ,attribute13 okl_lease_applications_b.attribute13%TYPE

Line 46: ,attribute10 okl_lease_applications_b.attribute10%TYPE

42: ,attribute6 okl_lease_applications_b.attribute6%TYPE
43: ,attribute7 okl_lease_applications_b.attribute7%TYPE
44: ,attribute8 okl_lease_applications_b.attribute8%TYPE
45: ,attribute9 okl_lease_applications_b.attribute9%TYPE
46: ,attribute10 okl_lease_applications_b.attribute10%TYPE
47: ,attribute11 okl_lease_applications_b.attribute11%TYPE
48: ,attribute12 okl_lease_applications_b.attribute12%TYPE
49: ,attribute13 okl_lease_applications_b.attribute13%TYPE
50: ,attribute14 okl_lease_applications_b.attribute14%TYPE

Line 47: ,attribute11 okl_lease_applications_b.attribute11%TYPE

43: ,attribute7 okl_lease_applications_b.attribute7%TYPE
44: ,attribute8 okl_lease_applications_b.attribute8%TYPE
45: ,attribute9 okl_lease_applications_b.attribute9%TYPE
46: ,attribute10 okl_lease_applications_b.attribute10%TYPE
47: ,attribute11 okl_lease_applications_b.attribute11%TYPE
48: ,attribute12 okl_lease_applications_b.attribute12%TYPE
49: ,attribute13 okl_lease_applications_b.attribute13%TYPE
50: ,attribute14 okl_lease_applications_b.attribute14%TYPE
51: ,attribute15 okl_lease_applications_b.attribute15%TYPE

Line 48: ,attribute12 okl_lease_applications_b.attribute12%TYPE

44: ,attribute8 okl_lease_applications_b.attribute8%TYPE
45: ,attribute9 okl_lease_applications_b.attribute9%TYPE
46: ,attribute10 okl_lease_applications_b.attribute10%TYPE
47: ,attribute11 okl_lease_applications_b.attribute11%TYPE
48: ,attribute12 okl_lease_applications_b.attribute12%TYPE
49: ,attribute13 okl_lease_applications_b.attribute13%TYPE
50: ,attribute14 okl_lease_applications_b.attribute14%TYPE
51: ,attribute15 okl_lease_applications_b.attribute15%TYPE
52: ,reference_number okl_lease_applications_b.reference_number%TYPE

Line 49: ,attribute13 okl_lease_applications_b.attribute13%TYPE

45: ,attribute9 okl_lease_applications_b.attribute9%TYPE
46: ,attribute10 okl_lease_applications_b.attribute10%TYPE
47: ,attribute11 okl_lease_applications_b.attribute11%TYPE
48: ,attribute12 okl_lease_applications_b.attribute12%TYPE
49: ,attribute13 okl_lease_applications_b.attribute13%TYPE
50: ,attribute14 okl_lease_applications_b.attribute14%TYPE
51: ,attribute15 okl_lease_applications_b.attribute15%TYPE
52: ,reference_number okl_lease_applications_b.reference_number%TYPE
53: ,application_status okl_lease_applications_b.application_status%TYPE

Line 50: ,attribute14 okl_lease_applications_b.attribute14%TYPE

46: ,attribute10 okl_lease_applications_b.attribute10%TYPE
47: ,attribute11 okl_lease_applications_b.attribute11%TYPE
48: ,attribute12 okl_lease_applications_b.attribute12%TYPE
49: ,attribute13 okl_lease_applications_b.attribute13%TYPE
50: ,attribute14 okl_lease_applications_b.attribute14%TYPE
51: ,attribute15 okl_lease_applications_b.attribute15%TYPE
52: ,reference_number okl_lease_applications_b.reference_number%TYPE
53: ,application_status okl_lease_applications_b.application_status%TYPE
54: ,valid_from okl_lease_applications_b.valid_from%TYPE

Line 51: ,attribute15 okl_lease_applications_b.attribute15%TYPE

47: ,attribute11 okl_lease_applications_b.attribute11%TYPE
48: ,attribute12 okl_lease_applications_b.attribute12%TYPE
49: ,attribute13 okl_lease_applications_b.attribute13%TYPE
50: ,attribute14 okl_lease_applications_b.attribute14%TYPE
51: ,attribute15 okl_lease_applications_b.attribute15%TYPE
52: ,reference_number okl_lease_applications_b.reference_number%TYPE
53: ,application_status okl_lease_applications_b.application_status%TYPE
54: ,valid_from okl_lease_applications_b.valid_from%TYPE
55: ,valid_to okl_lease_applications_b.valid_to%TYPE

Line 52: ,reference_number okl_lease_applications_b.reference_number%TYPE

48: ,attribute12 okl_lease_applications_b.attribute12%TYPE
49: ,attribute13 okl_lease_applications_b.attribute13%TYPE
50: ,attribute14 okl_lease_applications_b.attribute14%TYPE
51: ,attribute15 okl_lease_applications_b.attribute15%TYPE
52: ,reference_number okl_lease_applications_b.reference_number%TYPE
53: ,application_status okl_lease_applications_b.application_status%TYPE
54: ,valid_from okl_lease_applications_b.valid_from%TYPE
55: ,valid_to okl_lease_applications_b.valid_to%TYPE
56: ,org_id okl_lease_applications_b.org_id%TYPE

Line 53: ,application_status okl_lease_applications_b.application_status%TYPE

49: ,attribute13 okl_lease_applications_b.attribute13%TYPE
50: ,attribute14 okl_lease_applications_b.attribute14%TYPE
51: ,attribute15 okl_lease_applications_b.attribute15%TYPE
52: ,reference_number okl_lease_applications_b.reference_number%TYPE
53: ,application_status okl_lease_applications_b.application_status%TYPE
54: ,valid_from okl_lease_applications_b.valid_from%TYPE
55: ,valid_to okl_lease_applications_b.valid_to%TYPE
56: ,org_id okl_lease_applications_b.org_id%TYPE
57: ,inv_org_id okl_lease_applications_b.inv_org_id%TYPE

Line 54: ,valid_from okl_lease_applications_b.valid_from%TYPE

50: ,attribute14 okl_lease_applications_b.attribute14%TYPE
51: ,attribute15 okl_lease_applications_b.attribute15%TYPE
52: ,reference_number okl_lease_applications_b.reference_number%TYPE
53: ,application_status okl_lease_applications_b.application_status%TYPE
54: ,valid_from okl_lease_applications_b.valid_from%TYPE
55: ,valid_to okl_lease_applications_b.valid_to%TYPE
56: ,org_id okl_lease_applications_b.org_id%TYPE
57: ,inv_org_id okl_lease_applications_b.inv_org_id%TYPE
58: ,prospect_id okl_lease_applications_b.prospect_id%TYPE

Line 55: ,valid_to okl_lease_applications_b.valid_to%TYPE

51: ,attribute15 okl_lease_applications_b.attribute15%TYPE
52: ,reference_number okl_lease_applications_b.reference_number%TYPE
53: ,application_status okl_lease_applications_b.application_status%TYPE
54: ,valid_from okl_lease_applications_b.valid_from%TYPE
55: ,valid_to okl_lease_applications_b.valid_to%TYPE
56: ,org_id okl_lease_applications_b.org_id%TYPE
57: ,inv_org_id okl_lease_applications_b.inv_org_id%TYPE
58: ,prospect_id okl_lease_applications_b.prospect_id%TYPE
59: ,prospect_address_id okl_lease_applications_b.prospect_address_id%TYPE

Line 56: ,org_id okl_lease_applications_b.org_id%TYPE

52: ,reference_number okl_lease_applications_b.reference_number%TYPE
53: ,application_status okl_lease_applications_b.application_status%TYPE
54: ,valid_from okl_lease_applications_b.valid_from%TYPE
55: ,valid_to okl_lease_applications_b.valid_to%TYPE
56: ,org_id okl_lease_applications_b.org_id%TYPE
57: ,inv_org_id okl_lease_applications_b.inv_org_id%TYPE
58: ,prospect_id okl_lease_applications_b.prospect_id%TYPE
59: ,prospect_address_id okl_lease_applications_b.prospect_address_id%TYPE
60: ,cust_acct_id okl_lease_applications_b.cust_acct_id%TYPE

Line 57: ,inv_org_id okl_lease_applications_b.inv_org_id%TYPE

53: ,application_status okl_lease_applications_b.application_status%TYPE
54: ,valid_from okl_lease_applications_b.valid_from%TYPE
55: ,valid_to okl_lease_applications_b.valid_to%TYPE
56: ,org_id okl_lease_applications_b.org_id%TYPE
57: ,inv_org_id okl_lease_applications_b.inv_org_id%TYPE
58: ,prospect_id okl_lease_applications_b.prospect_id%TYPE
59: ,prospect_address_id okl_lease_applications_b.prospect_address_id%TYPE
60: ,cust_acct_id okl_lease_applications_b.cust_acct_id%TYPE
61: ,industry_class okl_lease_applications_b.industry_class%TYPE

Line 58: ,prospect_id okl_lease_applications_b.prospect_id%TYPE

54: ,valid_from okl_lease_applications_b.valid_from%TYPE
55: ,valid_to okl_lease_applications_b.valid_to%TYPE
56: ,org_id okl_lease_applications_b.org_id%TYPE
57: ,inv_org_id okl_lease_applications_b.inv_org_id%TYPE
58: ,prospect_id okl_lease_applications_b.prospect_id%TYPE
59: ,prospect_address_id okl_lease_applications_b.prospect_address_id%TYPE
60: ,cust_acct_id okl_lease_applications_b.cust_acct_id%TYPE
61: ,industry_class okl_lease_applications_b.industry_class%TYPE
62: ,industry_code okl_lease_applications_b.industry_code%TYPE

Line 59: ,prospect_address_id okl_lease_applications_b.prospect_address_id%TYPE

55: ,valid_to okl_lease_applications_b.valid_to%TYPE
56: ,org_id okl_lease_applications_b.org_id%TYPE
57: ,inv_org_id okl_lease_applications_b.inv_org_id%TYPE
58: ,prospect_id okl_lease_applications_b.prospect_id%TYPE
59: ,prospect_address_id okl_lease_applications_b.prospect_address_id%TYPE
60: ,cust_acct_id okl_lease_applications_b.cust_acct_id%TYPE
61: ,industry_class okl_lease_applications_b.industry_class%TYPE
62: ,industry_code okl_lease_applications_b.industry_code%TYPE
63: ,currency_code okl_lease_applications_b.currency_code%TYPE

Line 60: ,cust_acct_id okl_lease_applications_b.cust_acct_id%TYPE

56: ,org_id okl_lease_applications_b.org_id%TYPE
57: ,inv_org_id okl_lease_applications_b.inv_org_id%TYPE
58: ,prospect_id okl_lease_applications_b.prospect_id%TYPE
59: ,prospect_address_id okl_lease_applications_b.prospect_address_id%TYPE
60: ,cust_acct_id okl_lease_applications_b.cust_acct_id%TYPE
61: ,industry_class okl_lease_applications_b.industry_class%TYPE
62: ,industry_code okl_lease_applications_b.industry_code%TYPE
63: ,currency_code okl_lease_applications_b.currency_code%TYPE
64: ,currency_conversion_type okl_lease_applications_b.currency_conversion_type%TYPE

Line 61: ,industry_class okl_lease_applications_b.industry_class%TYPE

57: ,inv_org_id okl_lease_applications_b.inv_org_id%TYPE
58: ,prospect_id okl_lease_applications_b.prospect_id%TYPE
59: ,prospect_address_id okl_lease_applications_b.prospect_address_id%TYPE
60: ,cust_acct_id okl_lease_applications_b.cust_acct_id%TYPE
61: ,industry_class okl_lease_applications_b.industry_class%TYPE
62: ,industry_code okl_lease_applications_b.industry_code%TYPE
63: ,currency_code okl_lease_applications_b.currency_code%TYPE
64: ,currency_conversion_type okl_lease_applications_b.currency_conversion_type%TYPE
65: ,currency_conversion_rate okl_lease_applications_b.currency_conversion_rate%TYPE

Line 62: ,industry_code okl_lease_applications_b.industry_code%TYPE

58: ,prospect_id okl_lease_applications_b.prospect_id%TYPE
59: ,prospect_address_id okl_lease_applications_b.prospect_address_id%TYPE
60: ,cust_acct_id okl_lease_applications_b.cust_acct_id%TYPE
61: ,industry_class okl_lease_applications_b.industry_class%TYPE
62: ,industry_code okl_lease_applications_b.industry_code%TYPE
63: ,currency_code okl_lease_applications_b.currency_code%TYPE
64: ,currency_conversion_type okl_lease_applications_b.currency_conversion_type%TYPE
65: ,currency_conversion_rate okl_lease_applications_b.currency_conversion_rate%TYPE
66: ,currency_conversion_date okl_lease_applications_b.currency_conversion_date%TYPE

Line 63: ,currency_code okl_lease_applications_b.currency_code%TYPE

59: ,prospect_address_id okl_lease_applications_b.prospect_address_id%TYPE
60: ,cust_acct_id okl_lease_applications_b.cust_acct_id%TYPE
61: ,industry_class okl_lease_applications_b.industry_class%TYPE
62: ,industry_code okl_lease_applications_b.industry_code%TYPE
63: ,currency_code okl_lease_applications_b.currency_code%TYPE
64: ,currency_conversion_type okl_lease_applications_b.currency_conversion_type%TYPE
65: ,currency_conversion_rate okl_lease_applications_b.currency_conversion_rate%TYPE
66: ,currency_conversion_date okl_lease_applications_b.currency_conversion_date%TYPE
67: ,leaseapp_template_id okl_lease_applications_b.leaseapp_template_id%TYPE

Line 64: ,currency_conversion_type okl_lease_applications_b.currency_conversion_type%TYPE

60: ,cust_acct_id okl_lease_applications_b.cust_acct_id%TYPE
61: ,industry_class okl_lease_applications_b.industry_class%TYPE
62: ,industry_code okl_lease_applications_b.industry_code%TYPE
63: ,currency_code okl_lease_applications_b.currency_code%TYPE
64: ,currency_conversion_type okl_lease_applications_b.currency_conversion_type%TYPE
65: ,currency_conversion_rate okl_lease_applications_b.currency_conversion_rate%TYPE
66: ,currency_conversion_date okl_lease_applications_b.currency_conversion_date%TYPE
67: ,leaseapp_template_id okl_lease_applications_b.leaseapp_template_id%TYPE
68: ,parent_leaseapp_id okl_lease_applications_b.parent_leaseapp_id%TYPE

Line 65: ,currency_conversion_rate okl_lease_applications_b.currency_conversion_rate%TYPE

61: ,industry_class okl_lease_applications_b.industry_class%TYPE
62: ,industry_code okl_lease_applications_b.industry_code%TYPE
63: ,currency_code okl_lease_applications_b.currency_code%TYPE
64: ,currency_conversion_type okl_lease_applications_b.currency_conversion_type%TYPE
65: ,currency_conversion_rate okl_lease_applications_b.currency_conversion_rate%TYPE
66: ,currency_conversion_date okl_lease_applications_b.currency_conversion_date%TYPE
67: ,leaseapp_template_id okl_lease_applications_b.leaseapp_template_id%TYPE
68: ,parent_leaseapp_id okl_lease_applications_b.parent_leaseapp_id%TYPE
69: ,credit_line_id okl_lease_applications_b.credit_line_id%TYPE

Line 66: ,currency_conversion_date okl_lease_applications_b.currency_conversion_date%TYPE

62: ,industry_code okl_lease_applications_b.industry_code%TYPE
63: ,currency_code okl_lease_applications_b.currency_code%TYPE
64: ,currency_conversion_type okl_lease_applications_b.currency_conversion_type%TYPE
65: ,currency_conversion_rate okl_lease_applications_b.currency_conversion_rate%TYPE
66: ,currency_conversion_date okl_lease_applications_b.currency_conversion_date%TYPE
67: ,leaseapp_template_id okl_lease_applications_b.leaseapp_template_id%TYPE
68: ,parent_leaseapp_id okl_lease_applications_b.parent_leaseapp_id%TYPE
69: ,credit_line_id okl_lease_applications_b.credit_line_id%TYPE
70: ,program_agreement_id okl_lease_applications_b.program_agreement_id%TYPE

Line 67: ,leaseapp_template_id okl_lease_applications_b.leaseapp_template_id%TYPE

63: ,currency_code okl_lease_applications_b.currency_code%TYPE
64: ,currency_conversion_type okl_lease_applications_b.currency_conversion_type%TYPE
65: ,currency_conversion_rate okl_lease_applications_b.currency_conversion_rate%TYPE
66: ,currency_conversion_date okl_lease_applications_b.currency_conversion_date%TYPE
67: ,leaseapp_template_id okl_lease_applications_b.leaseapp_template_id%TYPE
68: ,parent_leaseapp_id okl_lease_applications_b.parent_leaseapp_id%TYPE
69: ,credit_line_id okl_lease_applications_b.credit_line_id%TYPE
70: ,program_agreement_id okl_lease_applications_b.program_agreement_id%TYPE
71: ,master_lease_id okl_lease_applications_b.master_lease_id%TYPE

Line 68: ,parent_leaseapp_id okl_lease_applications_b.parent_leaseapp_id%TYPE

64: ,currency_conversion_type okl_lease_applications_b.currency_conversion_type%TYPE
65: ,currency_conversion_rate okl_lease_applications_b.currency_conversion_rate%TYPE
66: ,currency_conversion_date okl_lease_applications_b.currency_conversion_date%TYPE
67: ,leaseapp_template_id okl_lease_applications_b.leaseapp_template_id%TYPE
68: ,parent_leaseapp_id okl_lease_applications_b.parent_leaseapp_id%TYPE
69: ,credit_line_id okl_lease_applications_b.credit_line_id%TYPE
70: ,program_agreement_id okl_lease_applications_b.program_agreement_id%TYPE
71: ,master_lease_id okl_lease_applications_b.master_lease_id%TYPE
72: ,sales_rep_id okl_lease_applications_b.sales_rep_id%TYPE

Line 69: ,credit_line_id okl_lease_applications_b.credit_line_id%TYPE

65: ,currency_conversion_rate okl_lease_applications_b.currency_conversion_rate%TYPE
66: ,currency_conversion_date okl_lease_applications_b.currency_conversion_date%TYPE
67: ,leaseapp_template_id okl_lease_applications_b.leaseapp_template_id%TYPE
68: ,parent_leaseapp_id okl_lease_applications_b.parent_leaseapp_id%TYPE
69: ,credit_line_id okl_lease_applications_b.credit_line_id%TYPE
70: ,program_agreement_id okl_lease_applications_b.program_agreement_id%TYPE
71: ,master_lease_id okl_lease_applications_b.master_lease_id%TYPE
72: ,sales_rep_id okl_lease_applications_b.sales_rep_id%TYPE
73: ,sales_territory_id okl_lease_applications_b.sales_territory_id%TYPE

Line 70: ,program_agreement_id okl_lease_applications_b.program_agreement_id%TYPE

66: ,currency_conversion_date okl_lease_applications_b.currency_conversion_date%TYPE
67: ,leaseapp_template_id okl_lease_applications_b.leaseapp_template_id%TYPE
68: ,parent_leaseapp_id okl_lease_applications_b.parent_leaseapp_id%TYPE
69: ,credit_line_id okl_lease_applications_b.credit_line_id%TYPE
70: ,program_agreement_id okl_lease_applications_b.program_agreement_id%TYPE
71: ,master_lease_id okl_lease_applications_b.master_lease_id%TYPE
72: ,sales_rep_id okl_lease_applications_b.sales_rep_id%TYPE
73: ,sales_territory_id okl_lease_applications_b.sales_territory_id%TYPE
74: ,originating_vendor_id okl_lease_applications_b.originating_vendor_id%TYPE

Line 71: ,master_lease_id okl_lease_applications_b.master_lease_id%TYPE

67: ,leaseapp_template_id okl_lease_applications_b.leaseapp_template_id%TYPE
68: ,parent_leaseapp_id okl_lease_applications_b.parent_leaseapp_id%TYPE
69: ,credit_line_id okl_lease_applications_b.credit_line_id%TYPE
70: ,program_agreement_id okl_lease_applications_b.program_agreement_id%TYPE
71: ,master_lease_id okl_lease_applications_b.master_lease_id%TYPE
72: ,sales_rep_id okl_lease_applications_b.sales_rep_id%TYPE
73: ,sales_territory_id okl_lease_applications_b.sales_territory_id%TYPE
74: ,originating_vendor_id okl_lease_applications_b.originating_vendor_id%TYPE
75: ,lease_opportunity_id okl_lease_applications_b.lease_opportunity_id%TYPE

Line 72: ,sales_rep_id okl_lease_applications_b.sales_rep_id%TYPE

68: ,parent_leaseapp_id okl_lease_applications_b.parent_leaseapp_id%TYPE
69: ,credit_line_id okl_lease_applications_b.credit_line_id%TYPE
70: ,program_agreement_id okl_lease_applications_b.program_agreement_id%TYPE
71: ,master_lease_id okl_lease_applications_b.master_lease_id%TYPE
72: ,sales_rep_id okl_lease_applications_b.sales_rep_id%TYPE
73: ,sales_territory_id okl_lease_applications_b.sales_territory_id%TYPE
74: ,originating_vendor_id okl_lease_applications_b.originating_vendor_id%TYPE
75: ,lease_opportunity_id okl_lease_applications_b.lease_opportunity_id%TYPE
76: ,cr_exp_days okl_lease_applications_b.cr_exp_days%TYPE --VARANGAN - for bug#4747179

Line 73: ,sales_territory_id okl_lease_applications_b.sales_territory_id%TYPE

69: ,credit_line_id okl_lease_applications_b.credit_line_id%TYPE
70: ,program_agreement_id okl_lease_applications_b.program_agreement_id%TYPE
71: ,master_lease_id okl_lease_applications_b.master_lease_id%TYPE
72: ,sales_rep_id okl_lease_applications_b.sales_rep_id%TYPE
73: ,sales_territory_id okl_lease_applications_b.sales_territory_id%TYPE
74: ,originating_vendor_id okl_lease_applications_b.originating_vendor_id%TYPE
75: ,lease_opportunity_id okl_lease_applications_b.lease_opportunity_id%TYPE
76: ,cr_exp_days okl_lease_applications_b.cr_exp_days%TYPE --VARANGAN - for bug#4747179
77: ,action okl_lease_applications_b.action%TYPE --PAGARG Bug 4872271

Line 74: ,originating_vendor_id okl_lease_applications_b.originating_vendor_id%TYPE

70: ,program_agreement_id okl_lease_applications_b.program_agreement_id%TYPE
71: ,master_lease_id okl_lease_applications_b.master_lease_id%TYPE
72: ,sales_rep_id okl_lease_applications_b.sales_rep_id%TYPE
73: ,sales_territory_id okl_lease_applications_b.sales_territory_id%TYPE
74: ,originating_vendor_id okl_lease_applications_b.originating_vendor_id%TYPE
75: ,lease_opportunity_id okl_lease_applications_b.lease_opportunity_id%TYPE
76: ,cr_exp_days okl_lease_applications_b.cr_exp_days%TYPE --VARANGAN - for bug#4747179
77: ,action okl_lease_applications_b.action%TYPE --PAGARG Bug 4872271
78: ,orig_status okl_lease_applications_b.orig_status%TYPE --PAGARG Bug 4872271

Line 75: ,lease_opportunity_id okl_lease_applications_b.lease_opportunity_id%TYPE

71: ,master_lease_id okl_lease_applications_b.master_lease_id%TYPE
72: ,sales_rep_id okl_lease_applications_b.sales_rep_id%TYPE
73: ,sales_territory_id okl_lease_applications_b.sales_territory_id%TYPE
74: ,originating_vendor_id okl_lease_applications_b.originating_vendor_id%TYPE
75: ,lease_opportunity_id okl_lease_applications_b.lease_opportunity_id%TYPE
76: ,cr_exp_days okl_lease_applications_b.cr_exp_days%TYPE --VARANGAN - for bug#4747179
77: ,action okl_lease_applications_b.action%TYPE --PAGARG Bug 4872271
78: ,orig_status okl_lease_applications_b.orig_status%TYPE --PAGARG Bug 4872271
79: );

Line 76: ,cr_exp_days okl_lease_applications_b.cr_exp_days%TYPE --VARANGAN - for bug#4747179

72: ,sales_rep_id okl_lease_applications_b.sales_rep_id%TYPE
73: ,sales_territory_id okl_lease_applications_b.sales_territory_id%TYPE
74: ,originating_vendor_id okl_lease_applications_b.originating_vendor_id%TYPE
75: ,lease_opportunity_id okl_lease_applications_b.lease_opportunity_id%TYPE
76: ,cr_exp_days okl_lease_applications_b.cr_exp_days%TYPE --VARANGAN - for bug#4747179
77: ,action okl_lease_applications_b.action%TYPE --PAGARG Bug 4872271
78: ,orig_status okl_lease_applications_b.orig_status%TYPE --PAGARG Bug 4872271
79: );
80:

Line 77: ,action okl_lease_applications_b.action%TYPE --PAGARG Bug 4872271

73: ,sales_territory_id okl_lease_applications_b.sales_territory_id%TYPE
74: ,originating_vendor_id okl_lease_applications_b.originating_vendor_id%TYPE
75: ,lease_opportunity_id okl_lease_applications_b.lease_opportunity_id%TYPE
76: ,cr_exp_days okl_lease_applications_b.cr_exp_days%TYPE --VARANGAN - for bug#4747179
77: ,action okl_lease_applications_b.action%TYPE --PAGARG Bug 4872271
78: ,orig_status okl_lease_applications_b.orig_status%TYPE --PAGARG Bug 4872271
79: );
80:
81: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure

Line 78: ,orig_status okl_lease_applications_b.orig_status%TYPE --PAGARG Bug 4872271

74: ,originating_vendor_id okl_lease_applications_b.originating_vendor_id%TYPE
75: ,lease_opportunity_id okl_lease_applications_b.lease_opportunity_id%TYPE
76: ,cr_exp_days okl_lease_applications_b.cr_exp_days%TYPE --VARANGAN - for bug#4747179
77: ,action okl_lease_applications_b.action%TYPE --PAGARG Bug 4872271
78: ,orig_status okl_lease_applications_b.orig_status%TYPE --PAGARG Bug 4872271
79: );
80:
81: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
82: TYPE laptl_rec_type IS RECORD (

Line 90: id okl_lease_applications_b.id%TYPE

86: );
87:
88: -- view record structure
89: TYPE lapv_rec_type IS RECORD (
90: id okl_lease_applications_b.id%TYPE
91: ,object_version_number okl_lease_applications_b.object_version_number%TYPE
92: ,attribute_category okl_lease_applications_b.attribute_category%TYPE
93: ,attribute1 okl_lease_applications_b.attribute1%TYPE
94: ,attribute2 okl_lease_applications_b.attribute2%TYPE

Line 91: ,object_version_number okl_lease_applications_b.object_version_number%TYPE

87:
88: -- view record structure
89: TYPE lapv_rec_type IS RECORD (
90: id okl_lease_applications_b.id%TYPE
91: ,object_version_number okl_lease_applications_b.object_version_number%TYPE
92: ,attribute_category okl_lease_applications_b.attribute_category%TYPE
93: ,attribute1 okl_lease_applications_b.attribute1%TYPE
94: ,attribute2 okl_lease_applications_b.attribute2%TYPE
95: ,attribute3 okl_lease_applications_b.attribute3%TYPE

Line 92: ,attribute_category okl_lease_applications_b.attribute_category%TYPE

88: -- view record structure
89: TYPE lapv_rec_type IS RECORD (
90: id okl_lease_applications_b.id%TYPE
91: ,object_version_number okl_lease_applications_b.object_version_number%TYPE
92: ,attribute_category okl_lease_applications_b.attribute_category%TYPE
93: ,attribute1 okl_lease_applications_b.attribute1%TYPE
94: ,attribute2 okl_lease_applications_b.attribute2%TYPE
95: ,attribute3 okl_lease_applications_b.attribute3%TYPE
96: ,attribute4 okl_lease_applications_b.attribute4%TYPE

Line 93: ,attribute1 okl_lease_applications_b.attribute1%TYPE

89: TYPE lapv_rec_type IS RECORD (
90: id okl_lease_applications_b.id%TYPE
91: ,object_version_number okl_lease_applications_b.object_version_number%TYPE
92: ,attribute_category okl_lease_applications_b.attribute_category%TYPE
93: ,attribute1 okl_lease_applications_b.attribute1%TYPE
94: ,attribute2 okl_lease_applications_b.attribute2%TYPE
95: ,attribute3 okl_lease_applications_b.attribute3%TYPE
96: ,attribute4 okl_lease_applications_b.attribute4%TYPE
97: ,attribute5 okl_lease_applications_b.attribute5%TYPE

Line 94: ,attribute2 okl_lease_applications_b.attribute2%TYPE

90: id okl_lease_applications_b.id%TYPE
91: ,object_version_number okl_lease_applications_b.object_version_number%TYPE
92: ,attribute_category okl_lease_applications_b.attribute_category%TYPE
93: ,attribute1 okl_lease_applications_b.attribute1%TYPE
94: ,attribute2 okl_lease_applications_b.attribute2%TYPE
95: ,attribute3 okl_lease_applications_b.attribute3%TYPE
96: ,attribute4 okl_lease_applications_b.attribute4%TYPE
97: ,attribute5 okl_lease_applications_b.attribute5%TYPE
98: ,attribute6 okl_lease_applications_b.attribute6%TYPE

Line 95: ,attribute3 okl_lease_applications_b.attribute3%TYPE

91: ,object_version_number okl_lease_applications_b.object_version_number%TYPE
92: ,attribute_category okl_lease_applications_b.attribute_category%TYPE
93: ,attribute1 okl_lease_applications_b.attribute1%TYPE
94: ,attribute2 okl_lease_applications_b.attribute2%TYPE
95: ,attribute3 okl_lease_applications_b.attribute3%TYPE
96: ,attribute4 okl_lease_applications_b.attribute4%TYPE
97: ,attribute5 okl_lease_applications_b.attribute5%TYPE
98: ,attribute6 okl_lease_applications_b.attribute6%TYPE
99: ,attribute7 okl_lease_applications_b.attribute7%TYPE

Line 96: ,attribute4 okl_lease_applications_b.attribute4%TYPE

92: ,attribute_category okl_lease_applications_b.attribute_category%TYPE
93: ,attribute1 okl_lease_applications_b.attribute1%TYPE
94: ,attribute2 okl_lease_applications_b.attribute2%TYPE
95: ,attribute3 okl_lease_applications_b.attribute3%TYPE
96: ,attribute4 okl_lease_applications_b.attribute4%TYPE
97: ,attribute5 okl_lease_applications_b.attribute5%TYPE
98: ,attribute6 okl_lease_applications_b.attribute6%TYPE
99: ,attribute7 okl_lease_applications_b.attribute7%TYPE
100: ,attribute8 okl_lease_applications_b.attribute8%TYPE

Line 97: ,attribute5 okl_lease_applications_b.attribute5%TYPE

93: ,attribute1 okl_lease_applications_b.attribute1%TYPE
94: ,attribute2 okl_lease_applications_b.attribute2%TYPE
95: ,attribute3 okl_lease_applications_b.attribute3%TYPE
96: ,attribute4 okl_lease_applications_b.attribute4%TYPE
97: ,attribute5 okl_lease_applications_b.attribute5%TYPE
98: ,attribute6 okl_lease_applications_b.attribute6%TYPE
99: ,attribute7 okl_lease_applications_b.attribute7%TYPE
100: ,attribute8 okl_lease_applications_b.attribute8%TYPE
101: ,attribute9 okl_lease_applications_b.attribute9%TYPE

Line 98: ,attribute6 okl_lease_applications_b.attribute6%TYPE

94: ,attribute2 okl_lease_applications_b.attribute2%TYPE
95: ,attribute3 okl_lease_applications_b.attribute3%TYPE
96: ,attribute4 okl_lease_applications_b.attribute4%TYPE
97: ,attribute5 okl_lease_applications_b.attribute5%TYPE
98: ,attribute6 okl_lease_applications_b.attribute6%TYPE
99: ,attribute7 okl_lease_applications_b.attribute7%TYPE
100: ,attribute8 okl_lease_applications_b.attribute8%TYPE
101: ,attribute9 okl_lease_applications_b.attribute9%TYPE
102: ,attribute10 okl_lease_applications_b.attribute10%TYPE

Line 99: ,attribute7 okl_lease_applications_b.attribute7%TYPE

95: ,attribute3 okl_lease_applications_b.attribute3%TYPE
96: ,attribute4 okl_lease_applications_b.attribute4%TYPE
97: ,attribute5 okl_lease_applications_b.attribute5%TYPE
98: ,attribute6 okl_lease_applications_b.attribute6%TYPE
99: ,attribute7 okl_lease_applications_b.attribute7%TYPE
100: ,attribute8 okl_lease_applications_b.attribute8%TYPE
101: ,attribute9 okl_lease_applications_b.attribute9%TYPE
102: ,attribute10 okl_lease_applications_b.attribute10%TYPE
103: ,attribute11 okl_lease_applications_b.attribute11%TYPE

Line 100: ,attribute8 okl_lease_applications_b.attribute8%TYPE

96: ,attribute4 okl_lease_applications_b.attribute4%TYPE
97: ,attribute5 okl_lease_applications_b.attribute5%TYPE
98: ,attribute6 okl_lease_applications_b.attribute6%TYPE
99: ,attribute7 okl_lease_applications_b.attribute7%TYPE
100: ,attribute8 okl_lease_applications_b.attribute8%TYPE
101: ,attribute9 okl_lease_applications_b.attribute9%TYPE
102: ,attribute10 okl_lease_applications_b.attribute10%TYPE
103: ,attribute11 okl_lease_applications_b.attribute11%TYPE
104: ,attribute12 okl_lease_applications_b.attribute12%TYPE

Line 101: ,attribute9 okl_lease_applications_b.attribute9%TYPE

97: ,attribute5 okl_lease_applications_b.attribute5%TYPE
98: ,attribute6 okl_lease_applications_b.attribute6%TYPE
99: ,attribute7 okl_lease_applications_b.attribute7%TYPE
100: ,attribute8 okl_lease_applications_b.attribute8%TYPE
101: ,attribute9 okl_lease_applications_b.attribute9%TYPE
102: ,attribute10 okl_lease_applications_b.attribute10%TYPE
103: ,attribute11 okl_lease_applications_b.attribute11%TYPE
104: ,attribute12 okl_lease_applications_b.attribute12%TYPE
105: ,attribute13 okl_lease_applications_b.attribute13%TYPE

Line 102: ,attribute10 okl_lease_applications_b.attribute10%TYPE

98: ,attribute6 okl_lease_applications_b.attribute6%TYPE
99: ,attribute7 okl_lease_applications_b.attribute7%TYPE
100: ,attribute8 okl_lease_applications_b.attribute8%TYPE
101: ,attribute9 okl_lease_applications_b.attribute9%TYPE
102: ,attribute10 okl_lease_applications_b.attribute10%TYPE
103: ,attribute11 okl_lease_applications_b.attribute11%TYPE
104: ,attribute12 okl_lease_applications_b.attribute12%TYPE
105: ,attribute13 okl_lease_applications_b.attribute13%TYPE
106: ,attribute14 okl_lease_applications_b.attribute14%TYPE

Line 103: ,attribute11 okl_lease_applications_b.attribute11%TYPE

99: ,attribute7 okl_lease_applications_b.attribute7%TYPE
100: ,attribute8 okl_lease_applications_b.attribute8%TYPE
101: ,attribute9 okl_lease_applications_b.attribute9%TYPE
102: ,attribute10 okl_lease_applications_b.attribute10%TYPE
103: ,attribute11 okl_lease_applications_b.attribute11%TYPE
104: ,attribute12 okl_lease_applications_b.attribute12%TYPE
105: ,attribute13 okl_lease_applications_b.attribute13%TYPE
106: ,attribute14 okl_lease_applications_b.attribute14%TYPE
107: ,attribute15 okl_lease_applications_b.attribute15%TYPE

Line 104: ,attribute12 okl_lease_applications_b.attribute12%TYPE

100: ,attribute8 okl_lease_applications_b.attribute8%TYPE
101: ,attribute9 okl_lease_applications_b.attribute9%TYPE
102: ,attribute10 okl_lease_applications_b.attribute10%TYPE
103: ,attribute11 okl_lease_applications_b.attribute11%TYPE
104: ,attribute12 okl_lease_applications_b.attribute12%TYPE
105: ,attribute13 okl_lease_applications_b.attribute13%TYPE
106: ,attribute14 okl_lease_applications_b.attribute14%TYPE
107: ,attribute15 okl_lease_applications_b.attribute15%TYPE
108: ,reference_number okl_lease_applications_b.reference_number%TYPE

Line 105: ,attribute13 okl_lease_applications_b.attribute13%TYPE

101: ,attribute9 okl_lease_applications_b.attribute9%TYPE
102: ,attribute10 okl_lease_applications_b.attribute10%TYPE
103: ,attribute11 okl_lease_applications_b.attribute11%TYPE
104: ,attribute12 okl_lease_applications_b.attribute12%TYPE
105: ,attribute13 okl_lease_applications_b.attribute13%TYPE
106: ,attribute14 okl_lease_applications_b.attribute14%TYPE
107: ,attribute15 okl_lease_applications_b.attribute15%TYPE
108: ,reference_number okl_lease_applications_b.reference_number%TYPE
109: ,application_status okl_lease_applications_b.application_status%TYPE

Line 106: ,attribute14 okl_lease_applications_b.attribute14%TYPE

102: ,attribute10 okl_lease_applications_b.attribute10%TYPE
103: ,attribute11 okl_lease_applications_b.attribute11%TYPE
104: ,attribute12 okl_lease_applications_b.attribute12%TYPE
105: ,attribute13 okl_lease_applications_b.attribute13%TYPE
106: ,attribute14 okl_lease_applications_b.attribute14%TYPE
107: ,attribute15 okl_lease_applications_b.attribute15%TYPE
108: ,reference_number okl_lease_applications_b.reference_number%TYPE
109: ,application_status okl_lease_applications_b.application_status%TYPE
110: ,valid_from okl_lease_applications_b.valid_from%TYPE

Line 107: ,attribute15 okl_lease_applications_b.attribute15%TYPE

103: ,attribute11 okl_lease_applications_b.attribute11%TYPE
104: ,attribute12 okl_lease_applications_b.attribute12%TYPE
105: ,attribute13 okl_lease_applications_b.attribute13%TYPE
106: ,attribute14 okl_lease_applications_b.attribute14%TYPE
107: ,attribute15 okl_lease_applications_b.attribute15%TYPE
108: ,reference_number okl_lease_applications_b.reference_number%TYPE
109: ,application_status okl_lease_applications_b.application_status%TYPE
110: ,valid_from okl_lease_applications_b.valid_from%TYPE
111: ,valid_to okl_lease_applications_b.valid_to%TYPE

Line 108: ,reference_number okl_lease_applications_b.reference_number%TYPE

104: ,attribute12 okl_lease_applications_b.attribute12%TYPE
105: ,attribute13 okl_lease_applications_b.attribute13%TYPE
106: ,attribute14 okl_lease_applications_b.attribute14%TYPE
107: ,attribute15 okl_lease_applications_b.attribute15%TYPE
108: ,reference_number okl_lease_applications_b.reference_number%TYPE
109: ,application_status okl_lease_applications_b.application_status%TYPE
110: ,valid_from okl_lease_applications_b.valid_from%TYPE
111: ,valid_to okl_lease_applications_b.valid_to%TYPE
112: ,org_id okl_lease_applications_b.org_id%TYPE

Line 109: ,application_status okl_lease_applications_b.application_status%TYPE

105: ,attribute13 okl_lease_applications_b.attribute13%TYPE
106: ,attribute14 okl_lease_applications_b.attribute14%TYPE
107: ,attribute15 okl_lease_applications_b.attribute15%TYPE
108: ,reference_number okl_lease_applications_b.reference_number%TYPE
109: ,application_status okl_lease_applications_b.application_status%TYPE
110: ,valid_from okl_lease_applications_b.valid_from%TYPE
111: ,valid_to okl_lease_applications_b.valid_to%TYPE
112: ,org_id okl_lease_applications_b.org_id%TYPE
113: ,inv_org_id okl_lease_applications_b.inv_org_id%TYPE

Line 110: ,valid_from okl_lease_applications_b.valid_from%TYPE

106: ,attribute14 okl_lease_applications_b.attribute14%TYPE
107: ,attribute15 okl_lease_applications_b.attribute15%TYPE
108: ,reference_number okl_lease_applications_b.reference_number%TYPE
109: ,application_status okl_lease_applications_b.application_status%TYPE
110: ,valid_from okl_lease_applications_b.valid_from%TYPE
111: ,valid_to okl_lease_applications_b.valid_to%TYPE
112: ,org_id okl_lease_applications_b.org_id%TYPE
113: ,inv_org_id okl_lease_applications_b.inv_org_id%TYPE
114: ,prospect_id okl_lease_applications_b.prospect_id%TYPE

Line 111: ,valid_to okl_lease_applications_b.valid_to%TYPE

107: ,attribute15 okl_lease_applications_b.attribute15%TYPE
108: ,reference_number okl_lease_applications_b.reference_number%TYPE
109: ,application_status okl_lease_applications_b.application_status%TYPE
110: ,valid_from okl_lease_applications_b.valid_from%TYPE
111: ,valid_to okl_lease_applications_b.valid_to%TYPE
112: ,org_id okl_lease_applications_b.org_id%TYPE
113: ,inv_org_id okl_lease_applications_b.inv_org_id%TYPE
114: ,prospect_id okl_lease_applications_b.prospect_id%TYPE
115: ,prospect_address_id okl_lease_applications_b.prospect_address_id%TYPE

Line 112: ,org_id okl_lease_applications_b.org_id%TYPE

108: ,reference_number okl_lease_applications_b.reference_number%TYPE
109: ,application_status okl_lease_applications_b.application_status%TYPE
110: ,valid_from okl_lease_applications_b.valid_from%TYPE
111: ,valid_to okl_lease_applications_b.valid_to%TYPE
112: ,org_id okl_lease_applications_b.org_id%TYPE
113: ,inv_org_id okl_lease_applications_b.inv_org_id%TYPE
114: ,prospect_id okl_lease_applications_b.prospect_id%TYPE
115: ,prospect_address_id okl_lease_applications_b.prospect_address_id%TYPE
116: ,cust_acct_id okl_lease_applications_b.cust_acct_id%TYPE

Line 113: ,inv_org_id okl_lease_applications_b.inv_org_id%TYPE

109: ,application_status okl_lease_applications_b.application_status%TYPE
110: ,valid_from okl_lease_applications_b.valid_from%TYPE
111: ,valid_to okl_lease_applications_b.valid_to%TYPE
112: ,org_id okl_lease_applications_b.org_id%TYPE
113: ,inv_org_id okl_lease_applications_b.inv_org_id%TYPE
114: ,prospect_id okl_lease_applications_b.prospect_id%TYPE
115: ,prospect_address_id okl_lease_applications_b.prospect_address_id%TYPE
116: ,cust_acct_id okl_lease_applications_b.cust_acct_id%TYPE
117: ,industry_class okl_lease_applications_b.industry_class%TYPE

Line 114: ,prospect_id okl_lease_applications_b.prospect_id%TYPE

110: ,valid_from okl_lease_applications_b.valid_from%TYPE
111: ,valid_to okl_lease_applications_b.valid_to%TYPE
112: ,org_id okl_lease_applications_b.org_id%TYPE
113: ,inv_org_id okl_lease_applications_b.inv_org_id%TYPE
114: ,prospect_id okl_lease_applications_b.prospect_id%TYPE
115: ,prospect_address_id okl_lease_applications_b.prospect_address_id%TYPE
116: ,cust_acct_id okl_lease_applications_b.cust_acct_id%TYPE
117: ,industry_class okl_lease_applications_b.industry_class%TYPE
118: ,industry_code okl_lease_applications_b.industry_code%TYPE

Line 115: ,prospect_address_id okl_lease_applications_b.prospect_address_id%TYPE

111: ,valid_to okl_lease_applications_b.valid_to%TYPE
112: ,org_id okl_lease_applications_b.org_id%TYPE
113: ,inv_org_id okl_lease_applications_b.inv_org_id%TYPE
114: ,prospect_id okl_lease_applications_b.prospect_id%TYPE
115: ,prospect_address_id okl_lease_applications_b.prospect_address_id%TYPE
116: ,cust_acct_id okl_lease_applications_b.cust_acct_id%TYPE
117: ,industry_class okl_lease_applications_b.industry_class%TYPE
118: ,industry_code okl_lease_applications_b.industry_code%TYPE
119: ,currency_code okl_lease_applications_b.currency_code%TYPE

Line 116: ,cust_acct_id okl_lease_applications_b.cust_acct_id%TYPE

112: ,org_id okl_lease_applications_b.org_id%TYPE
113: ,inv_org_id okl_lease_applications_b.inv_org_id%TYPE
114: ,prospect_id okl_lease_applications_b.prospect_id%TYPE
115: ,prospect_address_id okl_lease_applications_b.prospect_address_id%TYPE
116: ,cust_acct_id okl_lease_applications_b.cust_acct_id%TYPE
117: ,industry_class okl_lease_applications_b.industry_class%TYPE
118: ,industry_code okl_lease_applications_b.industry_code%TYPE
119: ,currency_code okl_lease_applications_b.currency_code%TYPE
120: ,currency_conversion_type okl_lease_applications_b.currency_conversion_type%TYPE

Line 117: ,industry_class okl_lease_applications_b.industry_class%TYPE

113: ,inv_org_id okl_lease_applications_b.inv_org_id%TYPE
114: ,prospect_id okl_lease_applications_b.prospect_id%TYPE
115: ,prospect_address_id okl_lease_applications_b.prospect_address_id%TYPE
116: ,cust_acct_id okl_lease_applications_b.cust_acct_id%TYPE
117: ,industry_class okl_lease_applications_b.industry_class%TYPE
118: ,industry_code okl_lease_applications_b.industry_code%TYPE
119: ,currency_code okl_lease_applications_b.currency_code%TYPE
120: ,currency_conversion_type okl_lease_applications_b.currency_conversion_type%TYPE
121: ,currency_conversion_rate okl_lease_applications_b.currency_conversion_rate%TYPE

Line 118: ,industry_code okl_lease_applications_b.industry_code%TYPE

114: ,prospect_id okl_lease_applications_b.prospect_id%TYPE
115: ,prospect_address_id okl_lease_applications_b.prospect_address_id%TYPE
116: ,cust_acct_id okl_lease_applications_b.cust_acct_id%TYPE
117: ,industry_class okl_lease_applications_b.industry_class%TYPE
118: ,industry_code okl_lease_applications_b.industry_code%TYPE
119: ,currency_code okl_lease_applications_b.currency_code%TYPE
120: ,currency_conversion_type okl_lease_applications_b.currency_conversion_type%TYPE
121: ,currency_conversion_rate okl_lease_applications_b.currency_conversion_rate%TYPE
122: ,currency_conversion_date okl_lease_applications_b.currency_conversion_date%TYPE

Line 119: ,currency_code okl_lease_applications_b.currency_code%TYPE

115: ,prospect_address_id okl_lease_applications_b.prospect_address_id%TYPE
116: ,cust_acct_id okl_lease_applications_b.cust_acct_id%TYPE
117: ,industry_class okl_lease_applications_b.industry_class%TYPE
118: ,industry_code okl_lease_applications_b.industry_code%TYPE
119: ,currency_code okl_lease_applications_b.currency_code%TYPE
120: ,currency_conversion_type okl_lease_applications_b.currency_conversion_type%TYPE
121: ,currency_conversion_rate okl_lease_applications_b.currency_conversion_rate%TYPE
122: ,currency_conversion_date okl_lease_applications_b.currency_conversion_date%TYPE
123: ,leaseapp_template_id okl_lease_applications_b.leaseapp_template_id%TYPE

Line 120: ,currency_conversion_type okl_lease_applications_b.currency_conversion_type%TYPE

116: ,cust_acct_id okl_lease_applications_b.cust_acct_id%TYPE
117: ,industry_class okl_lease_applications_b.industry_class%TYPE
118: ,industry_code okl_lease_applications_b.industry_code%TYPE
119: ,currency_code okl_lease_applications_b.currency_code%TYPE
120: ,currency_conversion_type okl_lease_applications_b.currency_conversion_type%TYPE
121: ,currency_conversion_rate okl_lease_applications_b.currency_conversion_rate%TYPE
122: ,currency_conversion_date okl_lease_applications_b.currency_conversion_date%TYPE
123: ,leaseapp_template_id okl_lease_applications_b.leaseapp_template_id%TYPE
124: ,parent_leaseapp_id okl_lease_applications_b.parent_leaseapp_id%TYPE

Line 121: ,currency_conversion_rate okl_lease_applications_b.currency_conversion_rate%TYPE

117: ,industry_class okl_lease_applications_b.industry_class%TYPE
118: ,industry_code okl_lease_applications_b.industry_code%TYPE
119: ,currency_code okl_lease_applications_b.currency_code%TYPE
120: ,currency_conversion_type okl_lease_applications_b.currency_conversion_type%TYPE
121: ,currency_conversion_rate okl_lease_applications_b.currency_conversion_rate%TYPE
122: ,currency_conversion_date okl_lease_applications_b.currency_conversion_date%TYPE
123: ,leaseapp_template_id okl_lease_applications_b.leaseapp_template_id%TYPE
124: ,parent_leaseapp_id okl_lease_applications_b.parent_leaseapp_id%TYPE
125: ,credit_line_id okl_lease_applications_b.credit_line_id%TYPE

Line 122: ,currency_conversion_date okl_lease_applications_b.currency_conversion_date%TYPE

118: ,industry_code okl_lease_applications_b.industry_code%TYPE
119: ,currency_code okl_lease_applications_b.currency_code%TYPE
120: ,currency_conversion_type okl_lease_applications_b.currency_conversion_type%TYPE
121: ,currency_conversion_rate okl_lease_applications_b.currency_conversion_rate%TYPE
122: ,currency_conversion_date okl_lease_applications_b.currency_conversion_date%TYPE
123: ,leaseapp_template_id okl_lease_applications_b.leaseapp_template_id%TYPE
124: ,parent_leaseapp_id okl_lease_applications_b.parent_leaseapp_id%TYPE
125: ,credit_line_id okl_lease_applications_b.credit_line_id%TYPE
126: ,program_agreement_id okl_lease_applications_b.program_agreement_id%TYPE

Line 123: ,leaseapp_template_id okl_lease_applications_b.leaseapp_template_id%TYPE

119: ,currency_code okl_lease_applications_b.currency_code%TYPE
120: ,currency_conversion_type okl_lease_applications_b.currency_conversion_type%TYPE
121: ,currency_conversion_rate okl_lease_applications_b.currency_conversion_rate%TYPE
122: ,currency_conversion_date okl_lease_applications_b.currency_conversion_date%TYPE
123: ,leaseapp_template_id okl_lease_applications_b.leaseapp_template_id%TYPE
124: ,parent_leaseapp_id okl_lease_applications_b.parent_leaseapp_id%TYPE
125: ,credit_line_id okl_lease_applications_b.credit_line_id%TYPE
126: ,program_agreement_id okl_lease_applications_b.program_agreement_id%TYPE
127: ,master_lease_id okl_lease_applications_b.master_lease_id%TYPE

Line 124: ,parent_leaseapp_id okl_lease_applications_b.parent_leaseapp_id%TYPE

120: ,currency_conversion_type okl_lease_applications_b.currency_conversion_type%TYPE
121: ,currency_conversion_rate okl_lease_applications_b.currency_conversion_rate%TYPE
122: ,currency_conversion_date okl_lease_applications_b.currency_conversion_date%TYPE
123: ,leaseapp_template_id okl_lease_applications_b.leaseapp_template_id%TYPE
124: ,parent_leaseapp_id okl_lease_applications_b.parent_leaseapp_id%TYPE
125: ,credit_line_id okl_lease_applications_b.credit_line_id%TYPE
126: ,program_agreement_id okl_lease_applications_b.program_agreement_id%TYPE
127: ,master_lease_id okl_lease_applications_b.master_lease_id%TYPE
128: ,sales_rep_id okl_lease_applications_b.sales_rep_id%TYPE

Line 125: ,credit_line_id okl_lease_applications_b.credit_line_id%TYPE

121: ,currency_conversion_rate okl_lease_applications_b.currency_conversion_rate%TYPE
122: ,currency_conversion_date okl_lease_applications_b.currency_conversion_date%TYPE
123: ,leaseapp_template_id okl_lease_applications_b.leaseapp_template_id%TYPE
124: ,parent_leaseapp_id okl_lease_applications_b.parent_leaseapp_id%TYPE
125: ,credit_line_id okl_lease_applications_b.credit_line_id%TYPE
126: ,program_agreement_id okl_lease_applications_b.program_agreement_id%TYPE
127: ,master_lease_id okl_lease_applications_b.master_lease_id%TYPE
128: ,sales_rep_id okl_lease_applications_b.sales_rep_id%TYPE
129: ,sales_territory_id okl_lease_applications_b.sales_territory_id%TYPE

Line 126: ,program_agreement_id okl_lease_applications_b.program_agreement_id%TYPE

122: ,currency_conversion_date okl_lease_applications_b.currency_conversion_date%TYPE
123: ,leaseapp_template_id okl_lease_applications_b.leaseapp_template_id%TYPE
124: ,parent_leaseapp_id okl_lease_applications_b.parent_leaseapp_id%TYPE
125: ,credit_line_id okl_lease_applications_b.credit_line_id%TYPE
126: ,program_agreement_id okl_lease_applications_b.program_agreement_id%TYPE
127: ,master_lease_id okl_lease_applications_b.master_lease_id%TYPE
128: ,sales_rep_id okl_lease_applications_b.sales_rep_id%TYPE
129: ,sales_territory_id okl_lease_applications_b.sales_territory_id%TYPE
130: ,originating_vendor_id okl_lease_applications_b.originating_vendor_id%TYPE

Line 127: ,master_lease_id okl_lease_applications_b.master_lease_id%TYPE

123: ,leaseapp_template_id okl_lease_applications_b.leaseapp_template_id%TYPE
124: ,parent_leaseapp_id okl_lease_applications_b.parent_leaseapp_id%TYPE
125: ,credit_line_id okl_lease_applications_b.credit_line_id%TYPE
126: ,program_agreement_id okl_lease_applications_b.program_agreement_id%TYPE
127: ,master_lease_id okl_lease_applications_b.master_lease_id%TYPE
128: ,sales_rep_id okl_lease_applications_b.sales_rep_id%TYPE
129: ,sales_territory_id okl_lease_applications_b.sales_territory_id%TYPE
130: ,originating_vendor_id okl_lease_applications_b.originating_vendor_id%TYPE
131: ,lease_opportunity_id okl_lease_applications_b.lease_opportunity_id%TYPE

Line 128: ,sales_rep_id okl_lease_applications_b.sales_rep_id%TYPE

124: ,parent_leaseapp_id okl_lease_applications_b.parent_leaseapp_id%TYPE
125: ,credit_line_id okl_lease_applications_b.credit_line_id%TYPE
126: ,program_agreement_id okl_lease_applications_b.program_agreement_id%TYPE
127: ,master_lease_id okl_lease_applications_b.master_lease_id%TYPE
128: ,sales_rep_id okl_lease_applications_b.sales_rep_id%TYPE
129: ,sales_territory_id okl_lease_applications_b.sales_territory_id%TYPE
130: ,originating_vendor_id okl_lease_applications_b.originating_vendor_id%TYPE
131: ,lease_opportunity_id okl_lease_applications_b.lease_opportunity_id%TYPE
132: ,short_description okl_lease_applications_tl.short_description%TYPE

Line 129: ,sales_territory_id okl_lease_applications_b.sales_territory_id%TYPE

125: ,credit_line_id okl_lease_applications_b.credit_line_id%TYPE
126: ,program_agreement_id okl_lease_applications_b.program_agreement_id%TYPE
127: ,master_lease_id okl_lease_applications_b.master_lease_id%TYPE
128: ,sales_rep_id okl_lease_applications_b.sales_rep_id%TYPE
129: ,sales_territory_id okl_lease_applications_b.sales_territory_id%TYPE
130: ,originating_vendor_id okl_lease_applications_b.originating_vendor_id%TYPE
131: ,lease_opportunity_id okl_lease_applications_b.lease_opportunity_id%TYPE
132: ,short_description okl_lease_applications_tl.short_description%TYPE
133: ,comments okl_lease_applications_tl.comments%TYPE

Line 130: ,originating_vendor_id okl_lease_applications_b.originating_vendor_id%TYPE

126: ,program_agreement_id okl_lease_applications_b.program_agreement_id%TYPE
127: ,master_lease_id okl_lease_applications_b.master_lease_id%TYPE
128: ,sales_rep_id okl_lease_applications_b.sales_rep_id%TYPE
129: ,sales_territory_id okl_lease_applications_b.sales_territory_id%TYPE
130: ,originating_vendor_id okl_lease_applications_b.originating_vendor_id%TYPE
131: ,lease_opportunity_id okl_lease_applications_b.lease_opportunity_id%TYPE
132: ,short_description okl_lease_applications_tl.short_description%TYPE
133: ,comments okl_lease_applications_tl.comments%TYPE
134: ,cr_exp_days okl_lease_applications_b.cr_exp_days%TYPE --VARANGAN for bug#4747179

Line 131: ,lease_opportunity_id okl_lease_applications_b.lease_opportunity_id%TYPE

127: ,master_lease_id okl_lease_applications_b.master_lease_id%TYPE
128: ,sales_rep_id okl_lease_applications_b.sales_rep_id%TYPE
129: ,sales_territory_id okl_lease_applications_b.sales_territory_id%TYPE
130: ,originating_vendor_id okl_lease_applications_b.originating_vendor_id%TYPE
131: ,lease_opportunity_id okl_lease_applications_b.lease_opportunity_id%TYPE
132: ,short_description okl_lease_applications_tl.short_description%TYPE
133: ,comments okl_lease_applications_tl.comments%TYPE
134: ,cr_exp_days okl_lease_applications_b.cr_exp_days%TYPE --VARANGAN for bug#4747179
135: ,action okl_lease_applications_b.action%TYPE --PAGARG Bug 4872271

Line 134: ,cr_exp_days okl_lease_applications_b.cr_exp_days%TYPE --VARANGAN for bug#4747179

130: ,originating_vendor_id okl_lease_applications_b.originating_vendor_id%TYPE
131: ,lease_opportunity_id okl_lease_applications_b.lease_opportunity_id%TYPE
132: ,short_description okl_lease_applications_tl.short_description%TYPE
133: ,comments okl_lease_applications_tl.comments%TYPE
134: ,cr_exp_days okl_lease_applications_b.cr_exp_days%TYPE --VARANGAN for bug#4747179
135: ,action okl_lease_applications_b.action%TYPE --PAGARG Bug 4872271
136: ,orig_status okl_lease_applications_b.orig_status%TYPE --PAGARG Bug 4872271
137: );
138:

Line 135: ,action okl_lease_applications_b.action%TYPE --PAGARG Bug 4872271

131: ,lease_opportunity_id okl_lease_applications_b.lease_opportunity_id%TYPE
132: ,short_description okl_lease_applications_tl.short_description%TYPE
133: ,comments okl_lease_applications_tl.comments%TYPE
134: ,cr_exp_days okl_lease_applications_b.cr_exp_days%TYPE --VARANGAN for bug#4747179
135: ,action okl_lease_applications_b.action%TYPE --PAGARG Bug 4872271
136: ,orig_status okl_lease_applications_b.orig_status%TYPE --PAGARG Bug 4872271
137: );
138:
139: TYPE lapv_tbl_type IS TABLE OF lapv_rec_type INDEX BY BINARY_INTEGER;

Line 136: ,orig_status okl_lease_applications_b.orig_status%TYPE --PAGARG Bug 4872271

132: ,short_description okl_lease_applications_tl.short_description%TYPE
133: ,comments okl_lease_applications_tl.comments%TYPE
134: ,cr_exp_days okl_lease_applications_b.cr_exp_days%TYPE --VARANGAN for bug#4747179
135: ,action okl_lease_applications_b.action%TYPE --PAGARG Bug 4872271
136: ,orig_status okl_lease_applications_b.orig_status%TYPE --PAGARG Bug 4872271
137: );
138:
139: TYPE lapv_tbl_type IS TABLE OF lapv_rec_type INDEX BY BINARY_INTEGER;
140: