eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_RENEW_UTIL_PVT dependencies on OKS_K_DEFAULTS

Line 60: cdt_type oks_k_defaults.cdt_type%TYPE,

56: template_language
57:
58: */
59: TYPE rnrl_rec_type IS RECORD(
60: cdt_type oks_k_defaults.cdt_type%TYPE,
61: jtot_object_code oks_k_defaults.jtot_object_code%TYPE,
62: renewal_type oks_k_defaults.renewal_type%TYPE,
63: renewal_pricing_type VARCHAR2(30), -- oks_k_defaults.renewal_pricing_type%type, oks_k_defaults is varchar2(3) while oks_k_headers_b is varchar(30)
64: markup_percent NUMBER, --oks_k_defaults.markup_percent%type, oks_k_defaults is number(5,2) while oks_k_headers_b is nukber

Line 61: jtot_object_code oks_k_defaults.jtot_object_code%TYPE,

57:
58: */
59: TYPE rnrl_rec_type IS RECORD(
60: cdt_type oks_k_defaults.cdt_type%TYPE,
61: jtot_object_code oks_k_defaults.jtot_object_code%TYPE,
62: renewal_type oks_k_defaults.renewal_type%TYPE,
63: renewal_pricing_type VARCHAR2(30), -- oks_k_defaults.renewal_pricing_type%type, oks_k_defaults is varchar2(3) while oks_k_headers_b is varchar(30)
64: markup_percent NUMBER, --oks_k_defaults.markup_percent%type, oks_k_defaults is number(5,2) while oks_k_headers_b is nukber
65: price_list_id1 oks_k_defaults.price_list_id1%TYPE,

Line 62: renewal_type oks_k_defaults.renewal_type%TYPE,

58: */
59: TYPE rnrl_rec_type IS RECORD(
60: cdt_type oks_k_defaults.cdt_type%TYPE,
61: jtot_object_code oks_k_defaults.jtot_object_code%TYPE,
62: renewal_type oks_k_defaults.renewal_type%TYPE,
63: renewal_pricing_type VARCHAR2(30), -- oks_k_defaults.renewal_pricing_type%type, oks_k_defaults is varchar2(3) while oks_k_headers_b is varchar(30)
64: markup_percent NUMBER, --oks_k_defaults.markup_percent%type, oks_k_defaults is number(5,2) while oks_k_headers_b is nukber
65: price_list_id1 oks_k_defaults.price_list_id1%TYPE,
66: price_list_id2 oks_k_defaults.price_list_id2%TYPE,

Line 63: renewal_pricing_type VARCHAR2(30), -- oks_k_defaults.renewal_pricing_type%type, oks_k_defaults is varchar2(3) while oks_k_headers_b is varchar(30)

59: TYPE rnrl_rec_type IS RECORD(
60: cdt_type oks_k_defaults.cdt_type%TYPE,
61: jtot_object_code oks_k_defaults.jtot_object_code%TYPE,
62: renewal_type oks_k_defaults.renewal_type%TYPE,
63: renewal_pricing_type VARCHAR2(30), -- oks_k_defaults.renewal_pricing_type%type, oks_k_defaults is varchar2(3) while oks_k_headers_b is varchar(30)
64: markup_percent NUMBER, --oks_k_defaults.markup_percent%type, oks_k_defaults is number(5,2) while oks_k_headers_b is nukber
65: price_list_id1 oks_k_defaults.price_list_id1%TYPE,
66: price_list_id2 oks_k_defaults.price_list_id2%TYPE,
67: pdf_id oks_k_defaults.pdf_id%TYPE,

Line 64: markup_percent NUMBER, --oks_k_defaults.markup_percent%type, oks_k_defaults is number(5,2) while oks_k_headers_b is nukber

60: cdt_type oks_k_defaults.cdt_type%TYPE,
61: jtot_object_code oks_k_defaults.jtot_object_code%TYPE,
62: renewal_type oks_k_defaults.renewal_type%TYPE,
63: renewal_pricing_type VARCHAR2(30), -- oks_k_defaults.renewal_pricing_type%type, oks_k_defaults is varchar2(3) while oks_k_headers_b is varchar(30)
64: markup_percent NUMBER, --oks_k_defaults.markup_percent%type, oks_k_defaults is number(5,2) while oks_k_headers_b is nukber
65: price_list_id1 oks_k_defaults.price_list_id1%TYPE,
66: price_list_id2 oks_k_defaults.price_list_id2%TYPE,
67: pdf_id oks_k_defaults.pdf_id%TYPE,
68: qcl_id oks_k_defaults.qcl_id%TYPE,

Line 65: price_list_id1 oks_k_defaults.price_list_id1%TYPE,

61: jtot_object_code oks_k_defaults.jtot_object_code%TYPE,
62: renewal_type oks_k_defaults.renewal_type%TYPE,
63: renewal_pricing_type VARCHAR2(30), -- oks_k_defaults.renewal_pricing_type%type, oks_k_defaults is varchar2(3) while oks_k_headers_b is varchar(30)
64: markup_percent NUMBER, --oks_k_defaults.markup_percent%type, oks_k_defaults is number(5,2) while oks_k_headers_b is nukber
65: price_list_id1 oks_k_defaults.price_list_id1%TYPE,
66: price_list_id2 oks_k_defaults.price_list_id2%TYPE,
67: pdf_id oks_k_defaults.pdf_id%TYPE,
68: qcl_id oks_k_defaults.qcl_id%TYPE,
69: cgp_new_id oks_k_defaults.cgp_new_id%TYPE,

Line 66: price_list_id2 oks_k_defaults.price_list_id2%TYPE,

62: renewal_type oks_k_defaults.renewal_type%TYPE,
63: renewal_pricing_type VARCHAR2(30), -- oks_k_defaults.renewal_pricing_type%type, oks_k_defaults is varchar2(3) while oks_k_headers_b is varchar(30)
64: markup_percent NUMBER, --oks_k_defaults.markup_percent%type, oks_k_defaults is number(5,2) while oks_k_headers_b is nukber
65: price_list_id1 oks_k_defaults.price_list_id1%TYPE,
66: price_list_id2 oks_k_defaults.price_list_id2%TYPE,
67: pdf_id oks_k_defaults.pdf_id%TYPE,
68: qcl_id oks_k_defaults.qcl_id%TYPE,
69: cgp_new_id oks_k_defaults.cgp_new_id%TYPE,
70: cgp_renew_id oks_k_defaults.cgp_renew_id%TYPE,

Line 67: pdf_id oks_k_defaults.pdf_id%TYPE,

63: renewal_pricing_type VARCHAR2(30), -- oks_k_defaults.renewal_pricing_type%type, oks_k_defaults is varchar2(3) while oks_k_headers_b is varchar(30)
64: markup_percent NUMBER, --oks_k_defaults.markup_percent%type, oks_k_defaults is number(5,2) while oks_k_headers_b is nukber
65: price_list_id1 oks_k_defaults.price_list_id1%TYPE,
66: price_list_id2 oks_k_defaults.price_list_id2%TYPE,
67: pdf_id oks_k_defaults.pdf_id%TYPE,
68: qcl_id oks_k_defaults.qcl_id%TYPE,
69: cgp_new_id oks_k_defaults.cgp_new_id%TYPE,
70: cgp_renew_id oks_k_defaults.cgp_renew_id%TYPE,
71: po_required_yn oks_k_defaults.po_required_yn%TYPE,

Line 68: qcl_id oks_k_defaults.qcl_id%TYPE,

64: markup_percent NUMBER, --oks_k_defaults.markup_percent%type, oks_k_defaults is number(5,2) while oks_k_headers_b is nukber
65: price_list_id1 oks_k_defaults.price_list_id1%TYPE,
66: price_list_id2 oks_k_defaults.price_list_id2%TYPE,
67: pdf_id oks_k_defaults.pdf_id%TYPE,
68: qcl_id oks_k_defaults.qcl_id%TYPE,
69: cgp_new_id oks_k_defaults.cgp_new_id%TYPE,
70: cgp_renew_id oks_k_defaults.cgp_renew_id%TYPE,
71: po_required_yn oks_k_defaults.po_required_yn%TYPE,
72: credit_amount oks_k_defaults.credit_amount%TYPE,

Line 69: cgp_new_id oks_k_defaults.cgp_new_id%TYPE,

65: price_list_id1 oks_k_defaults.price_list_id1%TYPE,
66: price_list_id2 oks_k_defaults.price_list_id2%TYPE,
67: pdf_id oks_k_defaults.pdf_id%TYPE,
68: qcl_id oks_k_defaults.qcl_id%TYPE,
69: cgp_new_id oks_k_defaults.cgp_new_id%TYPE,
70: cgp_renew_id oks_k_defaults.cgp_renew_id%TYPE,
71: po_required_yn oks_k_defaults.po_required_yn%TYPE,
72: credit_amount oks_k_defaults.credit_amount%TYPE,
73: rle_code oks_k_defaults.rle_code%TYPE,

Line 70: cgp_renew_id oks_k_defaults.cgp_renew_id%TYPE,

66: price_list_id2 oks_k_defaults.price_list_id2%TYPE,
67: pdf_id oks_k_defaults.pdf_id%TYPE,
68: qcl_id oks_k_defaults.qcl_id%TYPE,
69: cgp_new_id oks_k_defaults.cgp_new_id%TYPE,
70: cgp_renew_id oks_k_defaults.cgp_renew_id%TYPE,
71: po_required_yn oks_k_defaults.po_required_yn%TYPE,
72: credit_amount oks_k_defaults.credit_amount%TYPE,
73: rle_code oks_k_defaults.rle_code%TYPE,
74: revenue_estimated_percent NUMBER, --oks_k_defaults.revenue_estimated_percent%type, oks_k_defaults is number(5,2) while oks_k_headers_b is number

Line 71: po_required_yn oks_k_defaults.po_required_yn%TYPE,

67: pdf_id oks_k_defaults.pdf_id%TYPE,
68: qcl_id oks_k_defaults.qcl_id%TYPE,
69: cgp_new_id oks_k_defaults.cgp_new_id%TYPE,
70: cgp_renew_id oks_k_defaults.cgp_renew_id%TYPE,
71: po_required_yn oks_k_defaults.po_required_yn%TYPE,
72: credit_amount oks_k_defaults.credit_amount%TYPE,
73: rle_code oks_k_defaults.rle_code%TYPE,
74: revenue_estimated_percent NUMBER, --oks_k_defaults.revenue_estimated_percent%type, oks_k_defaults is number(5,2) while oks_k_headers_b is number
75: revenue_estimated_duration oks_k_defaults.revenue_estimated_duration%TYPE,

Line 72: credit_amount oks_k_defaults.credit_amount%TYPE,

68: qcl_id oks_k_defaults.qcl_id%TYPE,
69: cgp_new_id oks_k_defaults.cgp_new_id%TYPE,
70: cgp_renew_id oks_k_defaults.cgp_renew_id%TYPE,
71: po_required_yn oks_k_defaults.po_required_yn%TYPE,
72: credit_amount oks_k_defaults.credit_amount%TYPE,
73: rle_code oks_k_defaults.rle_code%TYPE,
74: revenue_estimated_percent NUMBER, --oks_k_defaults.revenue_estimated_percent%type, oks_k_defaults is number(5,2) while oks_k_headers_b is number
75: revenue_estimated_duration oks_k_defaults.revenue_estimated_duration%TYPE,
76: revenue_estimated_period VARCHAR(30), --oks_k_defaults.revenue_estimated_period%type, oks_k_defaults is varchar2(20)while oks_k_headers_b is varchar(30)

Line 73: rle_code oks_k_defaults.rle_code%TYPE,

69: cgp_new_id oks_k_defaults.cgp_new_id%TYPE,
70: cgp_renew_id oks_k_defaults.cgp_renew_id%TYPE,
71: po_required_yn oks_k_defaults.po_required_yn%TYPE,
72: credit_amount oks_k_defaults.credit_amount%TYPE,
73: rle_code oks_k_defaults.rle_code%TYPE,
74: revenue_estimated_percent NUMBER, --oks_k_defaults.revenue_estimated_percent%type, oks_k_defaults is number(5,2) while oks_k_headers_b is number
75: revenue_estimated_duration oks_k_defaults.revenue_estimated_duration%TYPE,
76: revenue_estimated_period VARCHAR(30), --oks_k_defaults.revenue_estimated_period%type, oks_k_defaults is varchar2(20)while oks_k_headers_b is varchar(30)
77: function_name VARCHAR2(50),

Line 74: revenue_estimated_percent NUMBER, --oks_k_defaults.revenue_estimated_percent%type, oks_k_defaults is number(5,2) while oks_k_headers_b is number

70: cgp_renew_id oks_k_defaults.cgp_renew_id%TYPE,
71: po_required_yn oks_k_defaults.po_required_yn%TYPE,
72: credit_amount oks_k_defaults.credit_amount%TYPE,
73: rle_code oks_k_defaults.rle_code%TYPE,
74: revenue_estimated_percent NUMBER, --oks_k_defaults.revenue_estimated_percent%type, oks_k_defaults is number(5,2) while oks_k_headers_b is number
75: revenue_estimated_duration oks_k_defaults.revenue_estimated_duration%TYPE,
76: revenue_estimated_period VARCHAR(30), --oks_k_defaults.revenue_estimated_period%type, oks_k_defaults is varchar2(20)while oks_k_headers_b is varchar(30)
77: function_name VARCHAR2(50),
78: salesrep_name VARCHAR2(150),

Line 75: revenue_estimated_duration oks_k_defaults.revenue_estimated_duration%TYPE,

71: po_required_yn oks_k_defaults.po_required_yn%TYPE,
72: credit_amount oks_k_defaults.credit_amount%TYPE,
73: rle_code oks_k_defaults.rle_code%TYPE,
74: revenue_estimated_percent NUMBER, --oks_k_defaults.revenue_estimated_percent%type, oks_k_defaults is number(5,2) while oks_k_headers_b is number
75: revenue_estimated_duration oks_k_defaults.revenue_estimated_duration%TYPE,
76: revenue_estimated_period VARCHAR(30), --oks_k_defaults.revenue_estimated_period%type, oks_k_defaults is varchar2(20)while oks_k_headers_b is varchar(30)
77: function_name VARCHAR2(50),
78: salesrep_name VARCHAR2(150),
79: template_set_id oks_k_defaults.template_set_id%TYPE,

Line 76: revenue_estimated_period VARCHAR(30), --oks_k_defaults.revenue_estimated_period%type, oks_k_defaults is varchar2(20)while oks_k_headers_b is varchar(30)

72: credit_amount oks_k_defaults.credit_amount%TYPE,
73: rle_code oks_k_defaults.rle_code%TYPE,
74: revenue_estimated_percent NUMBER, --oks_k_defaults.revenue_estimated_percent%type, oks_k_defaults is number(5,2) while oks_k_headers_b is number
75: revenue_estimated_duration oks_k_defaults.revenue_estimated_duration%TYPE,
76: revenue_estimated_period VARCHAR(30), --oks_k_defaults.revenue_estimated_period%type, oks_k_defaults is varchar2(20)while oks_k_headers_b is varchar(30)
77: function_name VARCHAR2(50),
78: salesrep_name VARCHAR2(150),
79: template_set_id oks_k_defaults.template_set_id%TYPE,
80: threshold_currency oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency

Line 79: template_set_id oks_k_defaults.template_set_id%TYPE,

75: revenue_estimated_duration oks_k_defaults.revenue_estimated_duration%TYPE,
76: revenue_estimated_period VARCHAR(30), --oks_k_defaults.revenue_estimated_period%type, oks_k_defaults is varchar2(20)while oks_k_headers_b is varchar(30)
77: function_name VARCHAR2(50),
78: salesrep_name VARCHAR2(150),
79: template_set_id oks_k_defaults.template_set_id%TYPE,
80: threshold_currency oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
81: threshold_amount oks_k_defaults.threshold_amount%TYPE,
82: email_address oks_k_defaults.email_address%TYPE,
83: billing_profile_id oks_k_defaults.billing_profile_id%TYPE,

Line 80: threshold_currency oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency

76: revenue_estimated_period VARCHAR(30), --oks_k_defaults.revenue_estimated_period%type, oks_k_defaults is varchar2(20)while oks_k_headers_b is varchar(30)
77: function_name VARCHAR2(50),
78: salesrep_name VARCHAR2(150),
79: template_set_id oks_k_defaults.template_set_id%TYPE,
80: threshold_currency oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
81: threshold_amount oks_k_defaults.threshold_amount%TYPE,
82: email_address oks_k_defaults.email_address%TYPE,
83: billing_profile_id oks_k_defaults.billing_profile_id%TYPE,
84: user_id oks_k_defaults.user_id%TYPE,

Line 81: threshold_amount oks_k_defaults.threshold_amount%TYPE,

77: function_name VARCHAR2(50),
78: salesrep_name VARCHAR2(150),
79: template_set_id oks_k_defaults.template_set_id%TYPE,
80: threshold_currency oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
81: threshold_amount oks_k_defaults.threshold_amount%TYPE,
82: email_address oks_k_defaults.email_address%TYPE,
83: billing_profile_id oks_k_defaults.billing_profile_id%TYPE,
84: user_id oks_k_defaults.user_id%TYPE,
85: threshold_enabled_yn oks_k_defaults.threshold_enabled_yn%TYPE,

Line 82: email_address oks_k_defaults.email_address%TYPE,

78: salesrep_name VARCHAR2(150),
79: template_set_id oks_k_defaults.template_set_id%TYPE,
80: threshold_currency oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
81: threshold_amount oks_k_defaults.threshold_amount%TYPE,
82: email_address oks_k_defaults.email_address%TYPE,
83: billing_profile_id oks_k_defaults.billing_profile_id%TYPE,
84: user_id oks_k_defaults.user_id%TYPE,
85: threshold_enabled_yn oks_k_defaults.threshold_enabled_yn%TYPE,
86: grace_period VARCHAR(30), --oks_k_defaults.grace_period%type, oks_k_defaults is varchar2(20) while oks_k_headers_b is varchar(30)

Line 83: billing_profile_id oks_k_defaults.billing_profile_id%TYPE,

79: template_set_id oks_k_defaults.template_set_id%TYPE,
80: threshold_currency oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
81: threshold_amount oks_k_defaults.threshold_amount%TYPE,
82: email_address oks_k_defaults.email_address%TYPE,
83: billing_profile_id oks_k_defaults.billing_profile_id%TYPE,
84: user_id oks_k_defaults.user_id%TYPE,
85: threshold_enabled_yn oks_k_defaults.threshold_enabled_yn%TYPE,
86: grace_period VARCHAR(30), --oks_k_defaults.grace_period%type, oks_k_defaults is varchar2(20) while oks_k_headers_b is varchar(30)
87: grace_duration oks_k_defaults.grace_duration%TYPE,

Line 84: user_id oks_k_defaults.user_id%TYPE,

80: threshold_currency oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
81: threshold_amount oks_k_defaults.threshold_amount%TYPE,
82: email_address oks_k_defaults.email_address%TYPE,
83: billing_profile_id oks_k_defaults.billing_profile_id%TYPE,
84: user_id oks_k_defaults.user_id%TYPE,
85: threshold_enabled_yn oks_k_defaults.threshold_enabled_yn%TYPE,
86: grace_period VARCHAR(30), --oks_k_defaults.grace_period%type, oks_k_defaults is varchar2(20) while oks_k_headers_b is varchar(30)
87: grace_duration oks_k_defaults.grace_duration%TYPE,
88: payment_terms_id1 oks_k_defaults.payment_terms_id1%TYPE,

Line 85: threshold_enabled_yn oks_k_defaults.threshold_enabled_yn%TYPE,

81: threshold_amount oks_k_defaults.threshold_amount%TYPE,
82: email_address oks_k_defaults.email_address%TYPE,
83: billing_profile_id oks_k_defaults.billing_profile_id%TYPE,
84: user_id oks_k_defaults.user_id%TYPE,
85: threshold_enabled_yn oks_k_defaults.threshold_enabled_yn%TYPE,
86: grace_period VARCHAR(30), --oks_k_defaults.grace_period%type, oks_k_defaults is varchar2(20) while oks_k_headers_b is varchar(30)
87: grace_duration oks_k_defaults.grace_duration%TYPE,
88: payment_terms_id1 oks_k_defaults.payment_terms_id1%TYPE,
89: payment_terms_id2 oks_k_defaults.payment_terms_id2%TYPE,

Line 86: grace_period VARCHAR(30), --oks_k_defaults.grace_period%type, oks_k_defaults is varchar2(20) while oks_k_headers_b is varchar(30)

82: email_address oks_k_defaults.email_address%TYPE,
83: billing_profile_id oks_k_defaults.billing_profile_id%TYPE,
84: user_id oks_k_defaults.user_id%TYPE,
85: threshold_enabled_yn oks_k_defaults.threshold_enabled_yn%TYPE,
86: grace_period VARCHAR(30), --oks_k_defaults.grace_period%type, oks_k_defaults is varchar2(20) while oks_k_headers_b is varchar(30)
87: grace_duration oks_k_defaults.grace_duration%TYPE,
88: payment_terms_id1 oks_k_defaults.payment_terms_id1%TYPE,
89: payment_terms_id2 oks_k_defaults.payment_terms_id2%TYPE,
90: evergreen_threshold_curr oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency

Line 87: grace_duration oks_k_defaults.grace_duration%TYPE,

83: billing_profile_id oks_k_defaults.billing_profile_id%TYPE,
84: user_id oks_k_defaults.user_id%TYPE,
85: threshold_enabled_yn oks_k_defaults.threshold_enabled_yn%TYPE,
86: grace_period VARCHAR(30), --oks_k_defaults.grace_period%type, oks_k_defaults is varchar2(20) while oks_k_headers_b is varchar(30)
87: grace_duration oks_k_defaults.grace_duration%TYPE,
88: payment_terms_id1 oks_k_defaults.payment_terms_id1%TYPE,
89: payment_terms_id2 oks_k_defaults.payment_terms_id2%TYPE,
90: evergreen_threshold_curr oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
91: evergreen_threshold_amt oks_k_defaults.evergreen_threshold_amt%TYPE,

Line 88: payment_terms_id1 oks_k_defaults.payment_terms_id1%TYPE,

84: user_id oks_k_defaults.user_id%TYPE,
85: threshold_enabled_yn oks_k_defaults.threshold_enabled_yn%TYPE,
86: grace_period VARCHAR(30), --oks_k_defaults.grace_period%type, oks_k_defaults is varchar2(20) while oks_k_headers_b is varchar(30)
87: grace_duration oks_k_defaults.grace_duration%TYPE,
88: payment_terms_id1 oks_k_defaults.payment_terms_id1%TYPE,
89: payment_terms_id2 oks_k_defaults.payment_terms_id2%TYPE,
90: evergreen_threshold_curr oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
91: evergreen_threshold_amt oks_k_defaults.evergreen_threshold_amt%TYPE,
92: payment_method oks_k_defaults.payment_method%TYPE,

Line 89: payment_terms_id2 oks_k_defaults.payment_terms_id2%TYPE,

85: threshold_enabled_yn oks_k_defaults.threshold_enabled_yn%TYPE,
86: grace_period VARCHAR(30), --oks_k_defaults.grace_period%type, oks_k_defaults is varchar2(20) while oks_k_headers_b is varchar(30)
87: grace_duration oks_k_defaults.grace_duration%TYPE,
88: payment_terms_id1 oks_k_defaults.payment_terms_id1%TYPE,
89: payment_terms_id2 oks_k_defaults.payment_terms_id2%TYPE,
90: evergreen_threshold_curr oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
91: evergreen_threshold_amt oks_k_defaults.evergreen_threshold_amt%TYPE,
92: payment_method oks_k_defaults.payment_method%TYPE,
93: payment_threshold_curr oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency

Line 90: evergreen_threshold_curr oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency

86: grace_period VARCHAR(30), --oks_k_defaults.grace_period%type, oks_k_defaults is varchar2(20) while oks_k_headers_b is varchar(30)
87: grace_duration oks_k_defaults.grace_duration%TYPE,
88: payment_terms_id1 oks_k_defaults.payment_terms_id1%TYPE,
89: payment_terms_id2 oks_k_defaults.payment_terms_id2%TYPE,
90: evergreen_threshold_curr oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
91: evergreen_threshold_amt oks_k_defaults.evergreen_threshold_amt%TYPE,
92: payment_method oks_k_defaults.payment_method%TYPE,
93: payment_threshold_curr oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
94: payment_threshold_amt oks_k_defaults.payment_threshold_amt%TYPE,

Line 91: evergreen_threshold_amt oks_k_defaults.evergreen_threshold_amt%TYPE,

87: grace_duration oks_k_defaults.grace_duration%TYPE,
88: payment_terms_id1 oks_k_defaults.payment_terms_id1%TYPE,
89: payment_terms_id2 oks_k_defaults.payment_terms_id2%TYPE,
90: evergreen_threshold_curr oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
91: evergreen_threshold_amt oks_k_defaults.evergreen_threshold_amt%TYPE,
92: payment_method oks_k_defaults.payment_method%TYPE,
93: payment_threshold_curr oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
94: payment_threshold_amt oks_k_defaults.payment_threshold_amt%TYPE,
95: interface_price_break oks_k_defaults.interface_price_break%TYPE,

Line 92: payment_method oks_k_defaults.payment_method%TYPE,

88: payment_terms_id1 oks_k_defaults.payment_terms_id1%TYPE,
89: payment_terms_id2 oks_k_defaults.payment_terms_id2%TYPE,
90: evergreen_threshold_curr oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
91: evergreen_threshold_amt oks_k_defaults.evergreen_threshold_amt%TYPE,
92: payment_method oks_k_defaults.payment_method%TYPE,
93: payment_threshold_curr oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
94: payment_threshold_amt oks_k_defaults.payment_threshold_amt%TYPE,
95: interface_price_break oks_k_defaults.interface_price_break%TYPE,
96: base_currency oks_k_defaults.base_currency%TYPE,

Line 93: payment_threshold_curr oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency

89: payment_terms_id2 oks_k_defaults.payment_terms_id2%TYPE,
90: evergreen_threshold_curr oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
91: evergreen_threshold_amt oks_k_defaults.evergreen_threshold_amt%TYPE,
92: payment_method oks_k_defaults.payment_method%TYPE,
93: payment_threshold_curr oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
94: payment_threshold_amt oks_k_defaults.payment_threshold_amt%TYPE,
95: interface_price_break oks_k_defaults.interface_price_break%TYPE,
96: base_currency oks_k_defaults.base_currency%TYPE,
97: approval_type oks_k_defaults.approval_type%TYPE,

Line 94: payment_threshold_amt oks_k_defaults.payment_threshold_amt%TYPE,

90: evergreen_threshold_curr oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
91: evergreen_threshold_amt oks_k_defaults.evergreen_threshold_amt%TYPE,
92: payment_method oks_k_defaults.payment_method%TYPE,
93: payment_threshold_curr oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
94: payment_threshold_amt oks_k_defaults.payment_threshold_amt%TYPE,
95: interface_price_break oks_k_defaults.interface_price_break%TYPE,
96: base_currency oks_k_defaults.base_currency%TYPE,
97: approval_type oks_k_defaults.approval_type%TYPE,
98: evergreen_approval_type oks_k_defaults.evergreen_approval_type%TYPE,

Line 95: interface_price_break oks_k_defaults.interface_price_break%TYPE,

91: evergreen_threshold_amt oks_k_defaults.evergreen_threshold_amt%TYPE,
92: payment_method oks_k_defaults.payment_method%TYPE,
93: payment_threshold_curr oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
94: payment_threshold_amt oks_k_defaults.payment_threshold_amt%TYPE,
95: interface_price_break oks_k_defaults.interface_price_break%TYPE,
96: base_currency oks_k_defaults.base_currency%TYPE,
97: approval_type oks_k_defaults.approval_type%TYPE,
98: evergreen_approval_type oks_k_defaults.evergreen_approval_type%TYPE,
99: online_approval_type oks_k_defaults.online_approval_type%TYPE,

Line 96: base_currency oks_k_defaults.base_currency%TYPE,

92: payment_method oks_k_defaults.payment_method%TYPE,
93: payment_threshold_curr oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
94: payment_threshold_amt oks_k_defaults.payment_threshold_amt%TYPE,
95: interface_price_break oks_k_defaults.interface_price_break%TYPE,
96: base_currency oks_k_defaults.base_currency%TYPE,
97: approval_type oks_k_defaults.approval_type%TYPE,
98: evergreen_approval_type oks_k_defaults.evergreen_approval_type%TYPE,
99: online_approval_type oks_k_defaults.online_approval_type%TYPE,
100: purchase_order_flag oks_k_defaults.purchase_order_flag%TYPE,

Line 97: approval_type oks_k_defaults.approval_type%TYPE,

93: payment_threshold_curr oks_k_defaults.base_currency%TYPE, --obsolete field, replace by base_currency
94: payment_threshold_amt oks_k_defaults.payment_threshold_amt%TYPE,
95: interface_price_break oks_k_defaults.interface_price_break%TYPE,
96: base_currency oks_k_defaults.base_currency%TYPE,
97: approval_type oks_k_defaults.approval_type%TYPE,
98: evergreen_approval_type oks_k_defaults.evergreen_approval_type%TYPE,
99: online_approval_type oks_k_defaults.online_approval_type%TYPE,
100: purchase_order_flag oks_k_defaults.purchase_order_flag%TYPE,
101: credit_card_flag oks_k_defaults.credit_card_flag%TYPE,

Line 98: evergreen_approval_type oks_k_defaults.evergreen_approval_type%TYPE,

94: payment_threshold_amt oks_k_defaults.payment_threshold_amt%TYPE,
95: interface_price_break oks_k_defaults.interface_price_break%TYPE,
96: base_currency oks_k_defaults.base_currency%TYPE,
97: approval_type oks_k_defaults.approval_type%TYPE,
98: evergreen_approval_type oks_k_defaults.evergreen_approval_type%TYPE,
99: online_approval_type oks_k_defaults.online_approval_type%TYPE,
100: purchase_order_flag oks_k_defaults.purchase_order_flag%TYPE,
101: credit_card_flag oks_k_defaults.credit_card_flag%TYPE,
102: wire_flag oks_k_defaults.wire_flag%TYPE,

Line 99: online_approval_type oks_k_defaults.online_approval_type%TYPE,

95: interface_price_break oks_k_defaults.interface_price_break%TYPE,
96: base_currency oks_k_defaults.base_currency%TYPE,
97: approval_type oks_k_defaults.approval_type%TYPE,
98: evergreen_approval_type oks_k_defaults.evergreen_approval_type%TYPE,
99: online_approval_type oks_k_defaults.online_approval_type%TYPE,
100: purchase_order_flag oks_k_defaults.purchase_order_flag%TYPE,
101: credit_card_flag oks_k_defaults.credit_card_flag%TYPE,
102: wire_flag oks_k_defaults.wire_flag%TYPE,
103: commitment_number_flag oks_k_defaults.commitment_number_flag%TYPE,

Line 100: purchase_order_flag oks_k_defaults.purchase_order_flag%TYPE,

96: base_currency oks_k_defaults.base_currency%TYPE,
97: approval_type oks_k_defaults.approval_type%TYPE,
98: evergreen_approval_type oks_k_defaults.evergreen_approval_type%TYPE,
99: online_approval_type oks_k_defaults.online_approval_type%TYPE,
100: purchase_order_flag oks_k_defaults.purchase_order_flag%TYPE,
101: credit_card_flag oks_k_defaults.credit_card_flag%TYPE,
102: wire_flag oks_k_defaults.wire_flag%TYPE,
103: commitment_number_flag oks_k_defaults.commitment_number_flag%TYPE,
104: check_flag oks_k_defaults.check_flag%TYPE,

Line 101: credit_card_flag oks_k_defaults.credit_card_flag%TYPE,

97: approval_type oks_k_defaults.approval_type%TYPE,
98: evergreen_approval_type oks_k_defaults.evergreen_approval_type%TYPE,
99: online_approval_type oks_k_defaults.online_approval_type%TYPE,
100: purchase_order_flag oks_k_defaults.purchase_order_flag%TYPE,
101: credit_card_flag oks_k_defaults.credit_card_flag%TYPE,
102: wire_flag oks_k_defaults.wire_flag%TYPE,
103: commitment_number_flag oks_k_defaults.commitment_number_flag%TYPE,
104: check_flag oks_k_defaults.check_flag%TYPE,
105: period_type oks_k_defaults.period_type%TYPE,

Line 102: wire_flag oks_k_defaults.wire_flag%TYPE,

98: evergreen_approval_type oks_k_defaults.evergreen_approval_type%TYPE,
99: online_approval_type oks_k_defaults.online_approval_type%TYPE,
100: purchase_order_flag oks_k_defaults.purchase_order_flag%TYPE,
101: credit_card_flag oks_k_defaults.credit_card_flag%TYPE,
102: wire_flag oks_k_defaults.wire_flag%TYPE,
103: commitment_number_flag oks_k_defaults.commitment_number_flag%TYPE,
104: check_flag oks_k_defaults.check_flag%TYPE,
105: period_type oks_k_defaults.period_type%TYPE,
106: period_start oks_k_defaults.period_start%TYPE,

Line 103: commitment_number_flag oks_k_defaults.commitment_number_flag%TYPE,

99: online_approval_type oks_k_defaults.online_approval_type%TYPE,
100: purchase_order_flag oks_k_defaults.purchase_order_flag%TYPE,
101: credit_card_flag oks_k_defaults.credit_card_flag%TYPE,
102: wire_flag oks_k_defaults.wire_flag%TYPE,
103: commitment_number_flag oks_k_defaults.commitment_number_flag%TYPE,
104: check_flag oks_k_defaults.check_flag%TYPE,
105: period_type oks_k_defaults.period_type%TYPE,
106: period_start oks_k_defaults.period_start%TYPE,
107: price_uom oks_k_defaults.price_uom%TYPE,

Line 104: check_flag oks_k_defaults.check_flag%TYPE,

100: purchase_order_flag oks_k_defaults.purchase_order_flag%TYPE,
101: credit_card_flag oks_k_defaults.credit_card_flag%TYPE,
102: wire_flag oks_k_defaults.wire_flag%TYPE,
103: commitment_number_flag oks_k_defaults.commitment_number_flag%TYPE,
104: check_flag oks_k_defaults.check_flag%TYPE,
105: period_type oks_k_defaults.period_type%TYPE,
106: period_start oks_k_defaults.period_start%TYPE,
107: price_uom oks_k_defaults.price_uom%TYPE,
108: template_language oks_k_defaults.template_language%TYPE

Line 105: period_type oks_k_defaults.period_type%TYPE,

101: credit_card_flag oks_k_defaults.credit_card_flag%TYPE,
102: wire_flag oks_k_defaults.wire_flag%TYPE,
103: commitment_number_flag oks_k_defaults.commitment_number_flag%TYPE,
104: check_flag oks_k_defaults.check_flag%TYPE,
105: period_type oks_k_defaults.period_type%TYPE,
106: period_start oks_k_defaults.period_start%TYPE,
107: price_uom oks_k_defaults.price_uom%TYPE,
108: template_language oks_k_defaults.template_language%TYPE
109: );

Line 106: period_start oks_k_defaults.period_start%TYPE,

102: wire_flag oks_k_defaults.wire_flag%TYPE,
103: commitment_number_flag oks_k_defaults.commitment_number_flag%TYPE,
104: check_flag oks_k_defaults.check_flag%TYPE,
105: period_type oks_k_defaults.period_type%TYPE,
106: period_start oks_k_defaults.period_start%TYPE,
107: price_uom oks_k_defaults.price_uom%TYPE,
108: template_language oks_k_defaults.template_language%TYPE
109: );
110:

Line 107: price_uom oks_k_defaults.price_uom%TYPE,

103: commitment_number_flag oks_k_defaults.commitment_number_flag%TYPE,
104: check_flag oks_k_defaults.check_flag%TYPE,
105: period_type oks_k_defaults.period_type%TYPE,
106: period_start oks_k_defaults.period_start%TYPE,
107: price_uom oks_k_defaults.price_uom%TYPE,
108: template_language oks_k_defaults.template_language%TYPE
109: );
110:
111: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKS_RENEW_UTIL_UNEXP_ERR';

Line 108: template_language oks_k_defaults.template_language%TYPE

104: check_flag oks_k_defaults.check_flag%TYPE,
105: period_type oks_k_defaults.period_type%TYPE,
106: period_start oks_k_defaults.period_start%TYPE,
107: price_uom oks_k_defaults.price_uom%TYPE,
108: template_language oks_k_defaults.template_language%TYPE
109: );
110:
111: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKS_RENEW_UTIL_UNEXP_ERR';
112: G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'SQLcode';