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.CS_EXP_TERMINATE_PVT dependencies on CS_CONTRACTS

Line 4: CONTRACT_ID CS_CONTRACTS_ALL.CONTRACT_ID%TYPE := NULL,

1: package body cs_exp_terminate_pvt as
2: /* $Header: csctexpb.pls 115.4 99/07/16 08:52:11 porting ship $ */
3: TYPE RContract_Rec_Type IS RECORD (
4: CONTRACT_ID CS_CONTRACTS_ALL.CONTRACT_ID%TYPE := NULL,
5: CONTRACT_NUMBER CS_CONTRACTS_ALL.CONTRACT_NUMBER%TYPE := NULL,
6: PRICE_LIST_ID CS_CONTRACTS_ALL.PRICE_LIST_ID%TYPE := NULL,
7: CURRENCY_CODE CS_CONTRACTS_ALL.CURRENCY_CODE%TYPE := NULL,
8: INVOICING_RULE_ID CS_CONTRACTS_ALL.INVOICING_RULE_ID%TYPE := NULL,

Line 5: CONTRACT_NUMBER CS_CONTRACTS_ALL.CONTRACT_NUMBER%TYPE := NULL,

1: package body cs_exp_terminate_pvt as
2: /* $Header: csctexpb.pls 115.4 99/07/16 08:52:11 porting ship $ */
3: TYPE RContract_Rec_Type IS RECORD (
4: CONTRACT_ID CS_CONTRACTS_ALL.CONTRACT_ID%TYPE := NULL,
5: CONTRACT_NUMBER CS_CONTRACTS_ALL.CONTRACT_NUMBER%TYPE := NULL,
6: PRICE_LIST_ID CS_CONTRACTS_ALL.PRICE_LIST_ID%TYPE := NULL,
7: CURRENCY_CODE CS_CONTRACTS_ALL.CURRENCY_CODE%TYPE := NULL,
8: INVOICING_RULE_ID CS_CONTRACTS_ALL.INVOICING_RULE_ID%TYPE := NULL,
9: ACCOUNTING_RULE_ID CS_CONTRACTS_ALL.ACCOUNTING_RULE_ID%TYPE := NULL,

Line 6: PRICE_LIST_ID CS_CONTRACTS_ALL.PRICE_LIST_ID%TYPE := NULL,

2: /* $Header: csctexpb.pls 115.4 99/07/16 08:52:11 porting ship $ */
3: TYPE RContract_Rec_Type IS RECORD (
4: CONTRACT_ID CS_CONTRACTS_ALL.CONTRACT_ID%TYPE := NULL,
5: CONTRACT_NUMBER CS_CONTRACTS_ALL.CONTRACT_NUMBER%TYPE := NULL,
6: PRICE_LIST_ID CS_CONTRACTS_ALL.PRICE_LIST_ID%TYPE := NULL,
7: CURRENCY_CODE CS_CONTRACTS_ALL.CURRENCY_CODE%TYPE := NULL,
8: INVOICING_RULE_ID CS_CONTRACTS_ALL.INVOICING_RULE_ID%TYPE := NULL,
9: ACCOUNTING_RULE_ID CS_CONTRACTS_ALL.ACCOUNTING_RULE_ID%TYPE := NULL,
10: BILL_TO_SITE_USE_ID CS_CONTRACTS_ALL.BILL_TO_SITE_USE_ID%TYPE := NULL,

Line 7: CURRENCY_CODE CS_CONTRACTS_ALL.CURRENCY_CODE%TYPE := NULL,

3: TYPE RContract_Rec_Type IS RECORD (
4: CONTRACT_ID CS_CONTRACTS_ALL.CONTRACT_ID%TYPE := NULL,
5: CONTRACT_NUMBER CS_CONTRACTS_ALL.CONTRACT_NUMBER%TYPE := NULL,
6: PRICE_LIST_ID CS_CONTRACTS_ALL.PRICE_LIST_ID%TYPE := NULL,
7: CURRENCY_CODE CS_CONTRACTS_ALL.CURRENCY_CODE%TYPE := NULL,
8: INVOICING_RULE_ID CS_CONTRACTS_ALL.INVOICING_RULE_ID%TYPE := NULL,
9: ACCOUNTING_RULE_ID CS_CONTRACTS_ALL.ACCOUNTING_RULE_ID%TYPE := NULL,
10: BILL_TO_SITE_USE_ID CS_CONTRACTS_ALL.BILL_TO_SITE_USE_ID%TYPE := NULL,
11: CONTRACT_STATUS_ID CS_CONTRACTS_ALL.CONTRACT_STATUS_ID%TYPE := NULL,

Line 8: INVOICING_RULE_ID CS_CONTRACTS_ALL.INVOICING_RULE_ID%TYPE := NULL,

4: CONTRACT_ID CS_CONTRACTS_ALL.CONTRACT_ID%TYPE := NULL,
5: CONTRACT_NUMBER CS_CONTRACTS_ALL.CONTRACT_NUMBER%TYPE := NULL,
6: PRICE_LIST_ID CS_CONTRACTS_ALL.PRICE_LIST_ID%TYPE := NULL,
7: CURRENCY_CODE CS_CONTRACTS_ALL.CURRENCY_CODE%TYPE := NULL,
8: INVOICING_RULE_ID CS_CONTRACTS_ALL.INVOICING_RULE_ID%TYPE := NULL,
9: ACCOUNTING_RULE_ID CS_CONTRACTS_ALL.ACCOUNTING_RULE_ID%TYPE := NULL,
10: BILL_TO_SITE_USE_ID CS_CONTRACTS_ALL.BILL_TO_SITE_USE_ID%TYPE := NULL,
11: CONTRACT_STATUS_ID CS_CONTRACTS_ALL.CONTRACT_STATUS_ID%TYPE := NULL,
12: CONTRACT_TYPE_ID CS_CONTRACTS_ALL.CONTRACT_TYPE_ID%TYPE := NULL,

Line 9: ACCOUNTING_RULE_ID CS_CONTRACTS_ALL.ACCOUNTING_RULE_ID%TYPE := NULL,

5: CONTRACT_NUMBER CS_CONTRACTS_ALL.CONTRACT_NUMBER%TYPE := NULL,
6: PRICE_LIST_ID CS_CONTRACTS_ALL.PRICE_LIST_ID%TYPE := NULL,
7: CURRENCY_CODE CS_CONTRACTS_ALL.CURRENCY_CODE%TYPE := NULL,
8: INVOICING_RULE_ID CS_CONTRACTS_ALL.INVOICING_RULE_ID%TYPE := NULL,
9: ACCOUNTING_RULE_ID CS_CONTRACTS_ALL.ACCOUNTING_RULE_ID%TYPE := NULL,
10: BILL_TO_SITE_USE_ID CS_CONTRACTS_ALL.BILL_TO_SITE_USE_ID%TYPE := NULL,
11: CONTRACT_STATUS_ID CS_CONTRACTS_ALL.CONTRACT_STATUS_ID%TYPE := NULL,
12: CONTRACT_TYPE_ID CS_CONTRACTS_ALL.CONTRACT_TYPE_ID%TYPE := NULL,
13: CUSTOMER_ID CS_CONTRACTS_ALL.CUSTOMER_ID%TYPE := NULL,

Line 10: BILL_TO_SITE_USE_ID CS_CONTRACTS_ALL.BILL_TO_SITE_USE_ID%TYPE := NULL,

6: PRICE_LIST_ID CS_CONTRACTS_ALL.PRICE_LIST_ID%TYPE := NULL,
7: CURRENCY_CODE CS_CONTRACTS_ALL.CURRENCY_CODE%TYPE := NULL,
8: INVOICING_RULE_ID CS_CONTRACTS_ALL.INVOICING_RULE_ID%TYPE := NULL,
9: ACCOUNTING_RULE_ID CS_CONTRACTS_ALL.ACCOUNTING_RULE_ID%TYPE := NULL,
10: BILL_TO_SITE_USE_ID CS_CONTRACTS_ALL.BILL_TO_SITE_USE_ID%TYPE := NULL,
11: CONTRACT_STATUS_ID CS_CONTRACTS_ALL.CONTRACT_STATUS_ID%TYPE := NULL,
12: CONTRACT_TYPE_ID CS_CONTRACTS_ALL.CONTRACT_TYPE_ID%TYPE := NULL,
13: CUSTOMER_ID CS_CONTRACTS_ALL.CUSTOMER_ID%TYPE := NULL,
14: DURATION CS_CONTRACTS_ALL.DURATION%TYPE := NULL,

Line 11: CONTRACT_STATUS_ID CS_CONTRACTS_ALL.CONTRACT_STATUS_ID%TYPE := NULL,

7: CURRENCY_CODE CS_CONTRACTS_ALL.CURRENCY_CODE%TYPE := NULL,
8: INVOICING_RULE_ID CS_CONTRACTS_ALL.INVOICING_RULE_ID%TYPE := NULL,
9: ACCOUNTING_RULE_ID CS_CONTRACTS_ALL.ACCOUNTING_RULE_ID%TYPE := NULL,
10: BILL_TO_SITE_USE_ID CS_CONTRACTS_ALL.BILL_TO_SITE_USE_ID%TYPE := NULL,
11: CONTRACT_STATUS_ID CS_CONTRACTS_ALL.CONTRACT_STATUS_ID%TYPE := NULL,
12: CONTRACT_TYPE_ID CS_CONTRACTS_ALL.CONTRACT_TYPE_ID%TYPE := NULL,
13: CUSTOMER_ID CS_CONTRACTS_ALL.CUSTOMER_ID%TYPE := NULL,
14: DURATION CS_CONTRACTS_ALL.DURATION%TYPE := NULL,
15: PERIOD_CODE CS_CONTRACTS_ALL.PERIOD_CODE%TYPE := NULL,

Line 12: CONTRACT_TYPE_ID CS_CONTRACTS_ALL.CONTRACT_TYPE_ID%TYPE := NULL,

8: INVOICING_RULE_ID CS_CONTRACTS_ALL.INVOICING_RULE_ID%TYPE := NULL,
9: ACCOUNTING_RULE_ID CS_CONTRACTS_ALL.ACCOUNTING_RULE_ID%TYPE := NULL,
10: BILL_TO_SITE_USE_ID CS_CONTRACTS_ALL.BILL_TO_SITE_USE_ID%TYPE := NULL,
11: CONTRACT_STATUS_ID CS_CONTRACTS_ALL.CONTRACT_STATUS_ID%TYPE := NULL,
12: CONTRACT_TYPE_ID CS_CONTRACTS_ALL.CONTRACT_TYPE_ID%TYPE := NULL,
13: CUSTOMER_ID CS_CONTRACTS_ALL.CUSTOMER_ID%TYPE := NULL,
14: DURATION CS_CONTRACTS_ALL.DURATION%TYPE := NULL,
15: PERIOD_CODE CS_CONTRACTS_ALL.PERIOD_CODE%TYPE := NULL,
16: START_DATE_ACTIVE CS_CONTRACTS_ALL.START_DATE_ACTIVE%TYPE := NULL,

Line 13: CUSTOMER_ID CS_CONTRACTS_ALL.CUSTOMER_ID%TYPE := NULL,

9: ACCOUNTING_RULE_ID CS_CONTRACTS_ALL.ACCOUNTING_RULE_ID%TYPE := NULL,
10: BILL_TO_SITE_USE_ID CS_CONTRACTS_ALL.BILL_TO_SITE_USE_ID%TYPE := NULL,
11: CONTRACT_STATUS_ID CS_CONTRACTS_ALL.CONTRACT_STATUS_ID%TYPE := NULL,
12: CONTRACT_TYPE_ID CS_CONTRACTS_ALL.CONTRACT_TYPE_ID%TYPE := NULL,
13: CUSTOMER_ID CS_CONTRACTS_ALL.CUSTOMER_ID%TYPE := NULL,
14: DURATION CS_CONTRACTS_ALL.DURATION%TYPE := NULL,
15: PERIOD_CODE CS_CONTRACTS_ALL.PERIOD_CODE%TYPE := NULL,
16: START_DATE_ACTIVE CS_CONTRACTS_ALL.START_DATE_ACTIVE%TYPE := NULL,
17: END_DATE_ACTIVE CS_CONTRACTS_ALL.END_DATE_ACTIVE%TYPE := NULL,

Line 14: DURATION CS_CONTRACTS_ALL.DURATION%TYPE := NULL,

10: BILL_TO_SITE_USE_ID CS_CONTRACTS_ALL.BILL_TO_SITE_USE_ID%TYPE := NULL,
11: CONTRACT_STATUS_ID CS_CONTRACTS_ALL.CONTRACT_STATUS_ID%TYPE := NULL,
12: CONTRACT_TYPE_ID CS_CONTRACTS_ALL.CONTRACT_TYPE_ID%TYPE := NULL,
13: CUSTOMER_ID CS_CONTRACTS_ALL.CUSTOMER_ID%TYPE := NULL,
14: DURATION CS_CONTRACTS_ALL.DURATION%TYPE := NULL,
15: PERIOD_CODE CS_CONTRACTS_ALL.PERIOD_CODE%TYPE := NULL,
16: START_DATE_ACTIVE CS_CONTRACTS_ALL.START_DATE_ACTIVE%TYPE := NULL,
17: END_DATE_ACTIVE CS_CONTRACTS_ALL.END_DATE_ACTIVE%TYPE := NULL,
18: AGREEMENT_ID CS_CONTRACTS_ALL.AGREEMENT_ID%TYPE := NULL,

Line 15: PERIOD_CODE CS_CONTRACTS_ALL.PERIOD_CODE%TYPE := NULL,

11: CONTRACT_STATUS_ID CS_CONTRACTS_ALL.CONTRACT_STATUS_ID%TYPE := NULL,
12: CONTRACT_TYPE_ID CS_CONTRACTS_ALL.CONTRACT_TYPE_ID%TYPE := NULL,
13: CUSTOMER_ID CS_CONTRACTS_ALL.CUSTOMER_ID%TYPE := NULL,
14: DURATION CS_CONTRACTS_ALL.DURATION%TYPE := NULL,
15: PERIOD_CODE CS_CONTRACTS_ALL.PERIOD_CODE%TYPE := NULL,
16: START_DATE_ACTIVE CS_CONTRACTS_ALL.START_DATE_ACTIVE%TYPE := NULL,
17: END_DATE_ACTIVE CS_CONTRACTS_ALL.END_DATE_ACTIVE%TYPE := NULL,
18: AGREEMENT_ID CS_CONTRACTS_ALL.AGREEMENT_ID%TYPE := NULL,
19: BILLING_FREQUENCY_PERIOD CS_CONTRACTS_ALL.BILLING_FREQUENCY_PERIOD%TYPE := NULL,

Line 16: START_DATE_ACTIVE CS_CONTRACTS_ALL.START_DATE_ACTIVE%TYPE := NULL,

12: CONTRACT_TYPE_ID CS_CONTRACTS_ALL.CONTRACT_TYPE_ID%TYPE := NULL,
13: CUSTOMER_ID CS_CONTRACTS_ALL.CUSTOMER_ID%TYPE := NULL,
14: DURATION CS_CONTRACTS_ALL.DURATION%TYPE := NULL,
15: PERIOD_CODE CS_CONTRACTS_ALL.PERIOD_CODE%TYPE := NULL,
16: START_DATE_ACTIVE CS_CONTRACTS_ALL.START_DATE_ACTIVE%TYPE := NULL,
17: END_DATE_ACTIVE CS_CONTRACTS_ALL.END_DATE_ACTIVE%TYPE := NULL,
18: AGREEMENT_ID CS_CONTRACTS_ALL.AGREEMENT_ID%TYPE := NULL,
19: BILLING_FREQUENCY_PERIOD CS_CONTRACTS_ALL.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
20: BILL_ON CS_CONTRACTS_ALL.BILL_ON%TYPE := NULL,

Line 17: END_DATE_ACTIVE CS_CONTRACTS_ALL.END_DATE_ACTIVE%TYPE := NULL,

13: CUSTOMER_ID CS_CONTRACTS_ALL.CUSTOMER_ID%TYPE := NULL,
14: DURATION CS_CONTRACTS_ALL.DURATION%TYPE := NULL,
15: PERIOD_CODE CS_CONTRACTS_ALL.PERIOD_CODE%TYPE := NULL,
16: START_DATE_ACTIVE CS_CONTRACTS_ALL.START_DATE_ACTIVE%TYPE := NULL,
17: END_DATE_ACTIVE CS_CONTRACTS_ALL.END_DATE_ACTIVE%TYPE := NULL,
18: AGREEMENT_ID CS_CONTRACTS_ALL.AGREEMENT_ID%TYPE := NULL,
19: BILLING_FREQUENCY_PERIOD CS_CONTRACTS_ALL.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
20: BILL_ON CS_CONTRACTS_ALL.BILL_ON%TYPE := NULL,
21: FIRST_BILL_DATE CS_CONTRACTS_ALL.FIRST_BILL_DATE%TYPE := NULL,

Line 18: AGREEMENT_ID CS_CONTRACTS_ALL.AGREEMENT_ID%TYPE := NULL,

14: DURATION CS_CONTRACTS_ALL.DURATION%TYPE := NULL,
15: PERIOD_CODE CS_CONTRACTS_ALL.PERIOD_CODE%TYPE := NULL,
16: START_DATE_ACTIVE CS_CONTRACTS_ALL.START_DATE_ACTIVE%TYPE := NULL,
17: END_DATE_ACTIVE CS_CONTRACTS_ALL.END_DATE_ACTIVE%TYPE := NULL,
18: AGREEMENT_ID CS_CONTRACTS_ALL.AGREEMENT_ID%TYPE := NULL,
19: BILLING_FREQUENCY_PERIOD CS_CONTRACTS_ALL.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
20: BILL_ON CS_CONTRACTS_ALL.BILL_ON%TYPE := NULL,
21: FIRST_BILL_DATE CS_CONTRACTS_ALL.FIRST_BILL_DATE%TYPE := NULL,
22: NEXT_BILL_DATE CS_CONTRACTS_ALL.NEXT_BILL_DATE%TYPE := NULL,

Line 19: BILLING_FREQUENCY_PERIOD CS_CONTRACTS_ALL.BILLING_FREQUENCY_PERIOD%TYPE := NULL,

15: PERIOD_CODE CS_CONTRACTS_ALL.PERIOD_CODE%TYPE := NULL,
16: START_DATE_ACTIVE CS_CONTRACTS_ALL.START_DATE_ACTIVE%TYPE := NULL,
17: END_DATE_ACTIVE CS_CONTRACTS_ALL.END_DATE_ACTIVE%TYPE := NULL,
18: AGREEMENT_ID CS_CONTRACTS_ALL.AGREEMENT_ID%TYPE := NULL,
19: BILLING_FREQUENCY_PERIOD CS_CONTRACTS_ALL.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
20: BILL_ON CS_CONTRACTS_ALL.BILL_ON%TYPE := NULL,
21: FIRST_BILL_DATE CS_CONTRACTS_ALL.FIRST_BILL_DATE%TYPE := NULL,
22: NEXT_BILL_DATE CS_CONTRACTS_ALL.NEXT_BILL_DATE%TYPE := NULL,
23: SALESPERSON_ID CS_CONTRACTS_ALL.SALESPERSON_ID%TYPE := NULL,

Line 20: BILL_ON CS_CONTRACTS_ALL.BILL_ON%TYPE := NULL,

16: START_DATE_ACTIVE CS_CONTRACTS_ALL.START_DATE_ACTIVE%TYPE := NULL,
17: END_DATE_ACTIVE CS_CONTRACTS_ALL.END_DATE_ACTIVE%TYPE := NULL,
18: AGREEMENT_ID CS_CONTRACTS_ALL.AGREEMENT_ID%TYPE := NULL,
19: BILLING_FREQUENCY_PERIOD CS_CONTRACTS_ALL.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
20: BILL_ON CS_CONTRACTS_ALL.BILL_ON%TYPE := NULL,
21: FIRST_BILL_DATE CS_CONTRACTS_ALL.FIRST_BILL_DATE%TYPE := NULL,
22: NEXT_BILL_DATE CS_CONTRACTS_ALL.NEXT_BILL_DATE%TYPE := NULL,
23: SALESPERSON_ID CS_CONTRACTS_ALL.SALESPERSON_ID%TYPE := NULL,
24: ORDERED_BY_CONTACT_ID CS_CONTRACTS_ALL.ORDERED_BY_CONTACT_ID%TYPE := NULL,

Line 21: FIRST_BILL_DATE CS_CONTRACTS_ALL.FIRST_BILL_DATE%TYPE := NULL,

17: END_DATE_ACTIVE CS_CONTRACTS_ALL.END_DATE_ACTIVE%TYPE := NULL,
18: AGREEMENT_ID CS_CONTRACTS_ALL.AGREEMENT_ID%TYPE := NULL,
19: BILLING_FREQUENCY_PERIOD CS_CONTRACTS_ALL.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
20: BILL_ON CS_CONTRACTS_ALL.BILL_ON%TYPE := NULL,
21: FIRST_BILL_DATE CS_CONTRACTS_ALL.FIRST_BILL_DATE%TYPE := NULL,
22: NEXT_BILL_DATE CS_CONTRACTS_ALL.NEXT_BILL_DATE%TYPE := NULL,
23: SALESPERSON_ID CS_CONTRACTS_ALL.SALESPERSON_ID%TYPE := NULL,
24: ORDERED_BY_CONTACT_ID CS_CONTRACTS_ALL.ORDERED_BY_CONTACT_ID%TYPE := NULL,
25: CONTRACT_TEMPLATE_ID CS_CONTRACTS_ALL.CONTRACT_TEMPLATE_ID%TYPE := NULL,

Line 22: NEXT_BILL_DATE CS_CONTRACTS_ALL.NEXT_BILL_DATE%TYPE := NULL,

18: AGREEMENT_ID CS_CONTRACTS_ALL.AGREEMENT_ID%TYPE := NULL,
19: BILLING_FREQUENCY_PERIOD CS_CONTRACTS_ALL.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
20: BILL_ON CS_CONTRACTS_ALL.BILL_ON%TYPE := NULL,
21: FIRST_BILL_DATE CS_CONTRACTS_ALL.FIRST_BILL_DATE%TYPE := NULL,
22: NEXT_BILL_DATE CS_CONTRACTS_ALL.NEXT_BILL_DATE%TYPE := NULL,
23: SALESPERSON_ID CS_CONTRACTS_ALL.SALESPERSON_ID%TYPE := NULL,
24: ORDERED_BY_CONTACT_ID CS_CONTRACTS_ALL.ORDERED_BY_CONTACT_ID%TYPE := NULL,
25: CONTRACT_TEMPLATE_ID CS_CONTRACTS_ALL.CONTRACT_TEMPLATE_ID%TYPE := NULL,
26: CONTRACT_GROUP_ID CS_CONTRACTS_ALL.CONTRACT_GROUP_ID%TYPE := NULL,

Line 23: SALESPERSON_ID CS_CONTRACTS_ALL.SALESPERSON_ID%TYPE := NULL,

19: BILLING_FREQUENCY_PERIOD CS_CONTRACTS_ALL.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
20: BILL_ON CS_CONTRACTS_ALL.BILL_ON%TYPE := NULL,
21: FIRST_BILL_DATE CS_CONTRACTS_ALL.FIRST_BILL_DATE%TYPE := NULL,
22: NEXT_BILL_DATE CS_CONTRACTS_ALL.NEXT_BILL_DATE%TYPE := NULL,
23: SALESPERSON_ID CS_CONTRACTS_ALL.SALESPERSON_ID%TYPE := NULL,
24: ORDERED_BY_CONTACT_ID CS_CONTRACTS_ALL.ORDERED_BY_CONTACT_ID%TYPE := NULL,
25: CONTRACT_TEMPLATE_ID CS_CONTRACTS_ALL.CONTRACT_TEMPLATE_ID%TYPE := NULL,
26: CONTRACT_GROUP_ID CS_CONTRACTS_ALL.CONTRACT_GROUP_ID%TYPE := NULL,
27: WORKFLOW CS_CONTRACTS_ALL.WORKFLOW%TYPE := NULL,

Line 24: ORDERED_BY_CONTACT_ID CS_CONTRACTS_ALL.ORDERED_BY_CONTACT_ID%TYPE := NULL,

20: BILL_ON CS_CONTRACTS_ALL.BILL_ON%TYPE := NULL,
21: FIRST_BILL_DATE CS_CONTRACTS_ALL.FIRST_BILL_DATE%TYPE := NULL,
22: NEXT_BILL_DATE CS_CONTRACTS_ALL.NEXT_BILL_DATE%TYPE := NULL,
23: SALESPERSON_ID CS_CONTRACTS_ALL.SALESPERSON_ID%TYPE := NULL,
24: ORDERED_BY_CONTACT_ID CS_CONTRACTS_ALL.ORDERED_BY_CONTACT_ID%TYPE := NULL,
25: CONTRACT_TEMPLATE_ID CS_CONTRACTS_ALL.CONTRACT_TEMPLATE_ID%TYPE := NULL,
26: CONTRACT_GROUP_ID CS_CONTRACTS_ALL.CONTRACT_GROUP_ID%TYPE := NULL,
27: WORKFLOW CS_CONTRACTS_ALL.WORKFLOW%TYPE := NULL,
28: WORKFLOW_PROCESS_ID CS_CONTRACTS_ALL.WORKFLOW_PROCESS_ID%TYPE := NULL,

Line 25: CONTRACT_TEMPLATE_ID CS_CONTRACTS_ALL.CONTRACT_TEMPLATE_ID%TYPE := NULL,

21: FIRST_BILL_DATE CS_CONTRACTS_ALL.FIRST_BILL_DATE%TYPE := NULL,
22: NEXT_BILL_DATE CS_CONTRACTS_ALL.NEXT_BILL_DATE%TYPE := NULL,
23: SALESPERSON_ID CS_CONTRACTS_ALL.SALESPERSON_ID%TYPE := NULL,
24: ORDERED_BY_CONTACT_ID CS_CONTRACTS_ALL.ORDERED_BY_CONTACT_ID%TYPE := NULL,
25: CONTRACT_TEMPLATE_ID CS_CONTRACTS_ALL.CONTRACT_TEMPLATE_ID%TYPE := NULL,
26: CONTRACT_GROUP_ID CS_CONTRACTS_ALL.CONTRACT_GROUP_ID%TYPE := NULL,
27: WORKFLOW CS_CONTRACTS_ALL.WORKFLOW%TYPE := NULL,
28: WORKFLOW_PROCESS_ID CS_CONTRACTS_ALL.WORKFLOW_PROCESS_ID%TYPE := NULL,
29: CREATE_SALES_ORDER CS_CONTRACTS_ALL.CREATE_SALES_ORDER%TYPE := NULL,

Line 26: CONTRACT_GROUP_ID CS_CONTRACTS_ALL.CONTRACT_GROUP_ID%TYPE := NULL,

22: NEXT_BILL_DATE CS_CONTRACTS_ALL.NEXT_BILL_DATE%TYPE := NULL,
23: SALESPERSON_ID CS_CONTRACTS_ALL.SALESPERSON_ID%TYPE := NULL,
24: ORDERED_BY_CONTACT_ID CS_CONTRACTS_ALL.ORDERED_BY_CONTACT_ID%TYPE := NULL,
25: CONTRACT_TEMPLATE_ID CS_CONTRACTS_ALL.CONTRACT_TEMPLATE_ID%TYPE := NULL,
26: CONTRACT_GROUP_ID CS_CONTRACTS_ALL.CONTRACT_GROUP_ID%TYPE := NULL,
27: WORKFLOW CS_CONTRACTS_ALL.WORKFLOW%TYPE := NULL,
28: WORKFLOW_PROCESS_ID CS_CONTRACTS_ALL.WORKFLOW_PROCESS_ID%TYPE := NULL,
29: CREATE_SALES_ORDER CS_CONTRACTS_ALL.CREATE_SALES_ORDER%TYPE := NULL,
30: SHIP_TO_SITE_USE_ID CS_CONTRACTS_ALL.SHIP_TO_SITE_USE_ID%TYPE := NULL,

Line 27: WORKFLOW CS_CONTRACTS_ALL.WORKFLOW%TYPE := NULL,

23: SALESPERSON_ID CS_CONTRACTS_ALL.SALESPERSON_ID%TYPE := NULL,
24: ORDERED_BY_CONTACT_ID CS_CONTRACTS_ALL.ORDERED_BY_CONTACT_ID%TYPE := NULL,
25: CONTRACT_TEMPLATE_ID CS_CONTRACTS_ALL.CONTRACT_TEMPLATE_ID%TYPE := NULL,
26: CONTRACT_GROUP_ID CS_CONTRACTS_ALL.CONTRACT_GROUP_ID%TYPE := NULL,
27: WORKFLOW CS_CONTRACTS_ALL.WORKFLOW%TYPE := NULL,
28: WORKFLOW_PROCESS_ID CS_CONTRACTS_ALL.WORKFLOW_PROCESS_ID%TYPE := NULL,
29: CREATE_SALES_ORDER CS_CONTRACTS_ALL.CREATE_SALES_ORDER%TYPE := NULL,
30: SHIP_TO_SITE_USE_ID CS_CONTRACTS_ALL.SHIP_TO_SITE_USE_ID%TYPE := NULL,
31: RENEWAL_RULE CS_CONTRACTS_ALL.RENEWAL_RULE%TYPE := NULL,

Line 28: WORKFLOW_PROCESS_ID CS_CONTRACTS_ALL.WORKFLOW_PROCESS_ID%TYPE := NULL,

24: ORDERED_BY_CONTACT_ID CS_CONTRACTS_ALL.ORDERED_BY_CONTACT_ID%TYPE := NULL,
25: CONTRACT_TEMPLATE_ID CS_CONTRACTS_ALL.CONTRACT_TEMPLATE_ID%TYPE := NULL,
26: CONTRACT_GROUP_ID CS_CONTRACTS_ALL.CONTRACT_GROUP_ID%TYPE := NULL,
27: WORKFLOW CS_CONTRACTS_ALL.WORKFLOW%TYPE := NULL,
28: WORKFLOW_PROCESS_ID CS_CONTRACTS_ALL.WORKFLOW_PROCESS_ID%TYPE := NULL,
29: CREATE_SALES_ORDER CS_CONTRACTS_ALL.CREATE_SALES_ORDER%TYPE := NULL,
30: SHIP_TO_SITE_USE_ID CS_CONTRACTS_ALL.SHIP_TO_SITE_USE_ID%TYPE := NULL,
31: RENEWAL_RULE CS_CONTRACTS_ALL.RENEWAL_RULE%TYPE := NULL,
32: TERMINATION_RULE CS_CONTRACTS_ALL.TERMINATION_RULE%TYPE := NULL,

Line 29: CREATE_SALES_ORDER CS_CONTRACTS_ALL.CREATE_SALES_ORDER%TYPE := NULL,

25: CONTRACT_TEMPLATE_ID CS_CONTRACTS_ALL.CONTRACT_TEMPLATE_ID%TYPE := NULL,
26: CONTRACT_GROUP_ID CS_CONTRACTS_ALL.CONTRACT_GROUP_ID%TYPE := NULL,
27: WORKFLOW CS_CONTRACTS_ALL.WORKFLOW%TYPE := NULL,
28: WORKFLOW_PROCESS_ID CS_CONTRACTS_ALL.WORKFLOW_PROCESS_ID%TYPE := NULL,
29: CREATE_SALES_ORDER CS_CONTRACTS_ALL.CREATE_SALES_ORDER%TYPE := NULL,
30: SHIP_TO_SITE_USE_ID CS_CONTRACTS_ALL.SHIP_TO_SITE_USE_ID%TYPE := NULL,
31: RENEWAL_RULE CS_CONTRACTS_ALL.RENEWAL_RULE%TYPE := NULL,
32: TERMINATION_RULE CS_CONTRACTS_ALL.TERMINATION_RULE%TYPE := NULL,
33: CONVERSION_TYPE_CODE CS_CONTRACTS_ALL.CONVERSION_TYPE_CODE%TYPE := NULL,

Line 30: SHIP_TO_SITE_USE_ID CS_CONTRACTS_ALL.SHIP_TO_SITE_USE_ID%TYPE := NULL,

26: CONTRACT_GROUP_ID CS_CONTRACTS_ALL.CONTRACT_GROUP_ID%TYPE := NULL,
27: WORKFLOW CS_CONTRACTS_ALL.WORKFLOW%TYPE := NULL,
28: WORKFLOW_PROCESS_ID CS_CONTRACTS_ALL.WORKFLOW_PROCESS_ID%TYPE := NULL,
29: CREATE_SALES_ORDER CS_CONTRACTS_ALL.CREATE_SALES_ORDER%TYPE := NULL,
30: SHIP_TO_SITE_USE_ID CS_CONTRACTS_ALL.SHIP_TO_SITE_USE_ID%TYPE := NULL,
31: RENEWAL_RULE CS_CONTRACTS_ALL.RENEWAL_RULE%TYPE := NULL,
32: TERMINATION_RULE CS_CONTRACTS_ALL.TERMINATION_RULE%TYPE := NULL,
33: CONVERSION_TYPE_CODE CS_CONTRACTS_ALL.CONVERSION_TYPE_CODE%TYPE := NULL,
34: CONVERSION_RATE CS_CONTRACTS_ALL.CONVERSION_RATE%TYPE := NULL,

Line 31: RENEWAL_RULE CS_CONTRACTS_ALL.RENEWAL_RULE%TYPE := NULL,

27: WORKFLOW CS_CONTRACTS_ALL.WORKFLOW%TYPE := NULL,
28: WORKFLOW_PROCESS_ID CS_CONTRACTS_ALL.WORKFLOW_PROCESS_ID%TYPE := NULL,
29: CREATE_SALES_ORDER CS_CONTRACTS_ALL.CREATE_SALES_ORDER%TYPE := NULL,
30: SHIP_TO_SITE_USE_ID CS_CONTRACTS_ALL.SHIP_TO_SITE_USE_ID%TYPE := NULL,
31: RENEWAL_RULE CS_CONTRACTS_ALL.RENEWAL_RULE%TYPE := NULL,
32: TERMINATION_RULE CS_CONTRACTS_ALL.TERMINATION_RULE%TYPE := NULL,
33: CONVERSION_TYPE_CODE CS_CONTRACTS_ALL.CONVERSION_TYPE_CODE%TYPE := NULL,
34: CONVERSION_RATE CS_CONTRACTS_ALL.CONVERSION_RATE%TYPE := NULL,
35: CONVERSION_DATE CS_CONTRACTS_ALL.CONVERSION_DATE%TYPE := NULL,

Line 32: TERMINATION_RULE CS_CONTRACTS_ALL.TERMINATION_RULE%TYPE := NULL,

28: WORKFLOW_PROCESS_ID CS_CONTRACTS_ALL.WORKFLOW_PROCESS_ID%TYPE := NULL,
29: CREATE_SALES_ORDER CS_CONTRACTS_ALL.CREATE_SALES_ORDER%TYPE := NULL,
30: SHIP_TO_SITE_USE_ID CS_CONTRACTS_ALL.SHIP_TO_SITE_USE_ID%TYPE := NULL,
31: RENEWAL_RULE CS_CONTRACTS_ALL.RENEWAL_RULE%TYPE := NULL,
32: TERMINATION_RULE CS_CONTRACTS_ALL.TERMINATION_RULE%TYPE := NULL,
33: CONVERSION_TYPE_CODE CS_CONTRACTS_ALL.CONVERSION_TYPE_CODE%TYPE := NULL,
34: CONVERSION_RATE CS_CONTRACTS_ALL.CONVERSION_RATE%TYPE := NULL,
35: CONVERSION_DATE CS_CONTRACTS_ALL.CONVERSION_DATE%TYPE := NULL,
36: SOURCE_CODE CS_CONTRACTS_ALL.SOURCE_CODE%TYPE := NULL,

Line 33: CONVERSION_TYPE_CODE CS_CONTRACTS_ALL.CONVERSION_TYPE_CODE%TYPE := NULL,

29: CREATE_SALES_ORDER CS_CONTRACTS_ALL.CREATE_SALES_ORDER%TYPE := NULL,
30: SHIP_TO_SITE_USE_ID CS_CONTRACTS_ALL.SHIP_TO_SITE_USE_ID%TYPE := NULL,
31: RENEWAL_RULE CS_CONTRACTS_ALL.RENEWAL_RULE%TYPE := NULL,
32: TERMINATION_RULE CS_CONTRACTS_ALL.TERMINATION_RULE%TYPE := NULL,
33: CONVERSION_TYPE_CODE CS_CONTRACTS_ALL.CONVERSION_TYPE_CODE%TYPE := NULL,
34: CONVERSION_RATE CS_CONTRACTS_ALL.CONVERSION_RATE%TYPE := NULL,
35: CONVERSION_DATE CS_CONTRACTS_ALL.CONVERSION_DATE%TYPE := NULL,
36: SOURCE_CODE CS_CONTRACTS_ALL.SOURCE_CODE%TYPE := NULL,
37: SOURCE_REFERENCE CS_CONTRACTS_ALL.SOURCE_REFERENCE%TYPE := NULL,

Line 34: CONVERSION_RATE CS_CONTRACTS_ALL.CONVERSION_RATE%TYPE := NULL,

30: SHIP_TO_SITE_USE_ID CS_CONTRACTS_ALL.SHIP_TO_SITE_USE_ID%TYPE := NULL,
31: RENEWAL_RULE CS_CONTRACTS_ALL.RENEWAL_RULE%TYPE := NULL,
32: TERMINATION_RULE CS_CONTRACTS_ALL.TERMINATION_RULE%TYPE := NULL,
33: CONVERSION_TYPE_CODE CS_CONTRACTS_ALL.CONVERSION_TYPE_CODE%TYPE := NULL,
34: CONVERSION_RATE CS_CONTRACTS_ALL.CONVERSION_RATE%TYPE := NULL,
35: CONVERSION_DATE CS_CONTRACTS_ALL.CONVERSION_DATE%TYPE := NULL,
36: SOURCE_CODE CS_CONTRACTS_ALL.SOURCE_CODE%TYPE := NULL,
37: SOURCE_REFERENCE CS_CONTRACTS_ALL.SOURCE_REFERENCE%TYPE := NULL,
38: TERMS_ID CS_CONTRACTS_ALL.TERMS_ID%TYPE := NULL,

Line 35: CONVERSION_DATE CS_CONTRACTS_ALL.CONVERSION_DATE%TYPE := NULL,

31: RENEWAL_RULE CS_CONTRACTS_ALL.RENEWAL_RULE%TYPE := NULL,
32: TERMINATION_RULE CS_CONTRACTS_ALL.TERMINATION_RULE%TYPE := NULL,
33: CONVERSION_TYPE_CODE CS_CONTRACTS_ALL.CONVERSION_TYPE_CODE%TYPE := NULL,
34: CONVERSION_RATE CS_CONTRACTS_ALL.CONVERSION_RATE%TYPE := NULL,
35: CONVERSION_DATE CS_CONTRACTS_ALL.CONVERSION_DATE%TYPE := NULL,
36: SOURCE_CODE CS_CONTRACTS_ALL.SOURCE_CODE%TYPE := NULL,
37: SOURCE_REFERENCE CS_CONTRACTS_ALL.SOURCE_REFERENCE%TYPE := NULL,
38: TERMS_ID CS_CONTRACTS_ALL.TERMS_ID%TYPE := NULL,
39: PO_NUMBER CS_CONTRACTS_ALL.PO_NUMBER%TYPE := NULL,

Line 36: SOURCE_CODE CS_CONTRACTS_ALL.SOURCE_CODE%TYPE := NULL,

32: TERMINATION_RULE CS_CONTRACTS_ALL.TERMINATION_RULE%TYPE := NULL,
33: CONVERSION_TYPE_CODE CS_CONTRACTS_ALL.CONVERSION_TYPE_CODE%TYPE := NULL,
34: CONVERSION_RATE CS_CONTRACTS_ALL.CONVERSION_RATE%TYPE := NULL,
35: CONVERSION_DATE CS_CONTRACTS_ALL.CONVERSION_DATE%TYPE := NULL,
36: SOURCE_CODE CS_CONTRACTS_ALL.SOURCE_CODE%TYPE := NULL,
37: SOURCE_REFERENCE CS_CONTRACTS_ALL.SOURCE_REFERENCE%TYPE := NULL,
38: TERMS_ID CS_CONTRACTS_ALL.TERMS_ID%TYPE := NULL,
39: PO_NUMBER CS_CONTRACTS_ALL.PO_NUMBER%TYPE := NULL,
40: TAX_HANDLING CS_CONTRACTS_ALL.TAX_HANDLING%TYPE := NULL,

Line 37: SOURCE_REFERENCE CS_CONTRACTS_ALL.SOURCE_REFERENCE%TYPE := NULL,

33: CONVERSION_TYPE_CODE CS_CONTRACTS_ALL.CONVERSION_TYPE_CODE%TYPE := NULL,
34: CONVERSION_RATE CS_CONTRACTS_ALL.CONVERSION_RATE%TYPE := NULL,
35: CONVERSION_DATE CS_CONTRACTS_ALL.CONVERSION_DATE%TYPE := NULL,
36: SOURCE_CODE CS_CONTRACTS_ALL.SOURCE_CODE%TYPE := NULL,
37: SOURCE_REFERENCE CS_CONTRACTS_ALL.SOURCE_REFERENCE%TYPE := NULL,
38: TERMS_ID CS_CONTRACTS_ALL.TERMS_ID%TYPE := NULL,
39: PO_NUMBER CS_CONTRACTS_ALL.PO_NUMBER%TYPE := NULL,
40: TAX_HANDLING CS_CONTRACTS_ALL.TAX_HANDLING%TYPE := NULL,
41: TAX_EXEMPT_NUM CS_CONTRACTS_ALL.TAX_EXEMPT_NUM%TYPE := NULL,

Line 38: TERMS_ID CS_CONTRACTS_ALL.TERMS_ID%TYPE := NULL,

34: CONVERSION_RATE CS_CONTRACTS_ALL.CONVERSION_RATE%TYPE := NULL,
35: CONVERSION_DATE CS_CONTRACTS_ALL.CONVERSION_DATE%TYPE := NULL,
36: SOURCE_CODE CS_CONTRACTS_ALL.SOURCE_CODE%TYPE := NULL,
37: SOURCE_REFERENCE CS_CONTRACTS_ALL.SOURCE_REFERENCE%TYPE := NULL,
38: TERMS_ID CS_CONTRACTS_ALL.TERMS_ID%TYPE := NULL,
39: PO_NUMBER CS_CONTRACTS_ALL.PO_NUMBER%TYPE := NULL,
40: TAX_HANDLING CS_CONTRACTS_ALL.TAX_HANDLING%TYPE := NULL,
41: TAX_EXEMPT_NUM CS_CONTRACTS_ALL.TAX_EXEMPT_NUM%TYPE := NULL,
42: TAX_EXEMPT_REASON_CODE CS_CONTRACTS_ALL.TAX_EXEMPT_REASON_CODE%TYPE := NULL,

Line 39: PO_NUMBER CS_CONTRACTS_ALL.PO_NUMBER%TYPE := NULL,

35: CONVERSION_DATE CS_CONTRACTS_ALL.CONVERSION_DATE%TYPE := NULL,
36: SOURCE_CODE CS_CONTRACTS_ALL.SOURCE_CODE%TYPE := NULL,
37: SOURCE_REFERENCE CS_CONTRACTS_ALL.SOURCE_REFERENCE%TYPE := NULL,
38: TERMS_ID CS_CONTRACTS_ALL.TERMS_ID%TYPE := NULL,
39: PO_NUMBER CS_CONTRACTS_ALL.PO_NUMBER%TYPE := NULL,
40: TAX_HANDLING CS_CONTRACTS_ALL.TAX_HANDLING%TYPE := NULL,
41: TAX_EXEMPT_NUM CS_CONTRACTS_ALL.TAX_EXEMPT_NUM%TYPE := NULL,
42: TAX_EXEMPT_REASON_CODE CS_CONTRACTS_ALL.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
43: CONTRACT_AMOUNT CS_CONTRACTS_ALL.CONTRACT_AMOUNT%TYPE := NULL,

Line 40: TAX_HANDLING CS_CONTRACTS_ALL.TAX_HANDLING%TYPE := NULL,

36: SOURCE_CODE CS_CONTRACTS_ALL.SOURCE_CODE%TYPE := NULL,
37: SOURCE_REFERENCE CS_CONTRACTS_ALL.SOURCE_REFERENCE%TYPE := NULL,
38: TERMS_ID CS_CONTRACTS_ALL.TERMS_ID%TYPE := NULL,
39: PO_NUMBER CS_CONTRACTS_ALL.PO_NUMBER%TYPE := NULL,
40: TAX_HANDLING CS_CONTRACTS_ALL.TAX_HANDLING%TYPE := NULL,
41: TAX_EXEMPT_NUM CS_CONTRACTS_ALL.TAX_EXEMPT_NUM%TYPE := NULL,
42: TAX_EXEMPT_REASON_CODE CS_CONTRACTS_ALL.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
43: CONTRACT_AMOUNT CS_CONTRACTS_ALL.CONTRACT_AMOUNT%TYPE := NULL,
44: AUTO_RENEWAL_FLAG CS_CONTRACTS_ALL.AUTO_RENEWAL_FLAG%TYPE := NULL,

Line 41: TAX_EXEMPT_NUM CS_CONTRACTS_ALL.TAX_EXEMPT_NUM%TYPE := NULL,

37: SOURCE_REFERENCE CS_CONTRACTS_ALL.SOURCE_REFERENCE%TYPE := NULL,
38: TERMS_ID CS_CONTRACTS_ALL.TERMS_ID%TYPE := NULL,
39: PO_NUMBER CS_CONTRACTS_ALL.PO_NUMBER%TYPE := NULL,
40: TAX_HANDLING CS_CONTRACTS_ALL.TAX_HANDLING%TYPE := NULL,
41: TAX_EXEMPT_NUM CS_CONTRACTS_ALL.TAX_EXEMPT_NUM%TYPE := NULL,
42: TAX_EXEMPT_REASON_CODE CS_CONTRACTS_ALL.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
43: CONTRACT_AMOUNT CS_CONTRACTS_ALL.CONTRACT_AMOUNT%TYPE := NULL,
44: AUTO_RENEWAL_FLAG CS_CONTRACTS_ALL.AUTO_RENEWAL_FLAG%TYPE := NULL,
45: ORIGINAL_END_DATE CS_CONTRACTS_ALL.ORIGINAL_END_DATE%TYPE := NULL,

Line 42: TAX_EXEMPT_REASON_CODE CS_CONTRACTS_ALL.TAX_EXEMPT_REASON_CODE%TYPE := NULL,

38: TERMS_ID CS_CONTRACTS_ALL.TERMS_ID%TYPE := NULL,
39: PO_NUMBER CS_CONTRACTS_ALL.PO_NUMBER%TYPE := NULL,
40: TAX_HANDLING CS_CONTRACTS_ALL.TAX_HANDLING%TYPE := NULL,
41: TAX_EXEMPT_NUM CS_CONTRACTS_ALL.TAX_EXEMPT_NUM%TYPE := NULL,
42: TAX_EXEMPT_REASON_CODE CS_CONTRACTS_ALL.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
43: CONTRACT_AMOUNT CS_CONTRACTS_ALL.CONTRACT_AMOUNT%TYPE := NULL,
44: AUTO_RENEWAL_FLAG CS_CONTRACTS_ALL.AUTO_RENEWAL_FLAG%TYPE := NULL,
45: ORIGINAL_END_DATE CS_CONTRACTS_ALL.ORIGINAL_END_DATE%TYPE := NULL,
46: TERMINATE_REASON_CODE CS_CONTRACTS_ALL.TERMINATE_REASON_CODE%TYPE := NULL,

Line 43: CONTRACT_AMOUNT CS_CONTRACTS_ALL.CONTRACT_AMOUNT%TYPE := NULL,

39: PO_NUMBER CS_CONTRACTS_ALL.PO_NUMBER%TYPE := NULL,
40: TAX_HANDLING CS_CONTRACTS_ALL.TAX_HANDLING%TYPE := NULL,
41: TAX_EXEMPT_NUM CS_CONTRACTS_ALL.TAX_EXEMPT_NUM%TYPE := NULL,
42: TAX_EXEMPT_REASON_CODE CS_CONTRACTS_ALL.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
43: CONTRACT_AMOUNT CS_CONTRACTS_ALL.CONTRACT_AMOUNT%TYPE := NULL,
44: AUTO_RENEWAL_FLAG CS_CONTRACTS_ALL.AUTO_RENEWAL_FLAG%TYPE := NULL,
45: ORIGINAL_END_DATE CS_CONTRACTS_ALL.ORIGINAL_END_DATE%TYPE := NULL,
46: TERMINATE_REASON_CODE CS_CONTRACTS_ALL.TERMINATE_REASON_CODE%TYPE := NULL,
47: DISCOUNT_ID CS_CONTRACTS_ALL.DISCOUNT_ID%TYPE := NULL,

Line 44: AUTO_RENEWAL_FLAG CS_CONTRACTS_ALL.AUTO_RENEWAL_FLAG%TYPE := NULL,

40: TAX_HANDLING CS_CONTRACTS_ALL.TAX_HANDLING%TYPE := NULL,
41: TAX_EXEMPT_NUM CS_CONTRACTS_ALL.TAX_EXEMPT_NUM%TYPE := NULL,
42: TAX_EXEMPT_REASON_CODE CS_CONTRACTS_ALL.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
43: CONTRACT_AMOUNT CS_CONTRACTS_ALL.CONTRACT_AMOUNT%TYPE := NULL,
44: AUTO_RENEWAL_FLAG CS_CONTRACTS_ALL.AUTO_RENEWAL_FLAG%TYPE := NULL,
45: ORIGINAL_END_DATE CS_CONTRACTS_ALL.ORIGINAL_END_DATE%TYPE := NULL,
46: TERMINATE_REASON_CODE CS_CONTRACTS_ALL.TERMINATE_REASON_CODE%TYPE := NULL,
47: DISCOUNT_ID CS_CONTRACTS_ALL.DISCOUNT_ID%TYPE := NULL,
48: ATTRIBUTE1 CS_CONTRACTS_ALL.ATTRIBUTE1%TYPE := NULL,

Line 45: ORIGINAL_END_DATE CS_CONTRACTS_ALL.ORIGINAL_END_DATE%TYPE := NULL,

41: TAX_EXEMPT_NUM CS_CONTRACTS_ALL.TAX_EXEMPT_NUM%TYPE := NULL,
42: TAX_EXEMPT_REASON_CODE CS_CONTRACTS_ALL.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
43: CONTRACT_AMOUNT CS_CONTRACTS_ALL.CONTRACT_AMOUNT%TYPE := NULL,
44: AUTO_RENEWAL_FLAG CS_CONTRACTS_ALL.AUTO_RENEWAL_FLAG%TYPE := NULL,
45: ORIGINAL_END_DATE CS_CONTRACTS_ALL.ORIGINAL_END_DATE%TYPE := NULL,
46: TERMINATE_REASON_CODE CS_CONTRACTS_ALL.TERMINATE_REASON_CODE%TYPE := NULL,
47: DISCOUNT_ID CS_CONTRACTS_ALL.DISCOUNT_ID%TYPE := NULL,
48: ATTRIBUTE1 CS_CONTRACTS_ALL.ATTRIBUTE1%TYPE := NULL,
49: ATTRIBUTE2 CS_CONTRACTS_ALL.ATTRIBUTE2%TYPE := NULL,

Line 46: TERMINATE_REASON_CODE CS_CONTRACTS_ALL.TERMINATE_REASON_CODE%TYPE := NULL,

42: TAX_EXEMPT_REASON_CODE CS_CONTRACTS_ALL.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
43: CONTRACT_AMOUNT CS_CONTRACTS_ALL.CONTRACT_AMOUNT%TYPE := NULL,
44: AUTO_RENEWAL_FLAG CS_CONTRACTS_ALL.AUTO_RENEWAL_FLAG%TYPE := NULL,
45: ORIGINAL_END_DATE CS_CONTRACTS_ALL.ORIGINAL_END_DATE%TYPE := NULL,
46: TERMINATE_REASON_CODE CS_CONTRACTS_ALL.TERMINATE_REASON_CODE%TYPE := NULL,
47: DISCOUNT_ID CS_CONTRACTS_ALL.DISCOUNT_ID%TYPE := NULL,
48: ATTRIBUTE1 CS_CONTRACTS_ALL.ATTRIBUTE1%TYPE := NULL,
49: ATTRIBUTE2 CS_CONTRACTS_ALL.ATTRIBUTE2%TYPE := NULL,
50: ATTRIBUTE3 CS_CONTRACTS_ALL.ATTRIBUTE3%TYPE := NULL,

Line 47: DISCOUNT_ID CS_CONTRACTS_ALL.DISCOUNT_ID%TYPE := NULL,

43: CONTRACT_AMOUNT CS_CONTRACTS_ALL.CONTRACT_AMOUNT%TYPE := NULL,
44: AUTO_RENEWAL_FLAG CS_CONTRACTS_ALL.AUTO_RENEWAL_FLAG%TYPE := NULL,
45: ORIGINAL_END_DATE CS_CONTRACTS_ALL.ORIGINAL_END_DATE%TYPE := NULL,
46: TERMINATE_REASON_CODE CS_CONTRACTS_ALL.TERMINATE_REASON_CODE%TYPE := NULL,
47: DISCOUNT_ID CS_CONTRACTS_ALL.DISCOUNT_ID%TYPE := NULL,
48: ATTRIBUTE1 CS_CONTRACTS_ALL.ATTRIBUTE1%TYPE := NULL,
49: ATTRIBUTE2 CS_CONTRACTS_ALL.ATTRIBUTE2%TYPE := NULL,
50: ATTRIBUTE3 CS_CONTRACTS_ALL.ATTRIBUTE3%TYPE := NULL,
51: ATTRIBUTE4 CS_CONTRACTS_ALL.ATTRIBUTE4%TYPE := NULL,

Line 48: ATTRIBUTE1 CS_CONTRACTS_ALL.ATTRIBUTE1%TYPE := NULL,

44: AUTO_RENEWAL_FLAG CS_CONTRACTS_ALL.AUTO_RENEWAL_FLAG%TYPE := NULL,
45: ORIGINAL_END_DATE CS_CONTRACTS_ALL.ORIGINAL_END_DATE%TYPE := NULL,
46: TERMINATE_REASON_CODE CS_CONTRACTS_ALL.TERMINATE_REASON_CODE%TYPE := NULL,
47: DISCOUNT_ID CS_CONTRACTS_ALL.DISCOUNT_ID%TYPE := NULL,
48: ATTRIBUTE1 CS_CONTRACTS_ALL.ATTRIBUTE1%TYPE := NULL,
49: ATTRIBUTE2 CS_CONTRACTS_ALL.ATTRIBUTE2%TYPE := NULL,
50: ATTRIBUTE3 CS_CONTRACTS_ALL.ATTRIBUTE3%TYPE := NULL,
51: ATTRIBUTE4 CS_CONTRACTS_ALL.ATTRIBUTE4%TYPE := NULL,
52: ATTRIBUTE5 CS_CONTRACTS_ALL.ATTRIBUTE5%TYPE := NULL,

Line 49: ATTRIBUTE2 CS_CONTRACTS_ALL.ATTRIBUTE2%TYPE := NULL,

45: ORIGINAL_END_DATE CS_CONTRACTS_ALL.ORIGINAL_END_DATE%TYPE := NULL,
46: TERMINATE_REASON_CODE CS_CONTRACTS_ALL.TERMINATE_REASON_CODE%TYPE := NULL,
47: DISCOUNT_ID CS_CONTRACTS_ALL.DISCOUNT_ID%TYPE := NULL,
48: ATTRIBUTE1 CS_CONTRACTS_ALL.ATTRIBUTE1%TYPE := NULL,
49: ATTRIBUTE2 CS_CONTRACTS_ALL.ATTRIBUTE2%TYPE := NULL,
50: ATTRIBUTE3 CS_CONTRACTS_ALL.ATTRIBUTE3%TYPE := NULL,
51: ATTRIBUTE4 CS_CONTRACTS_ALL.ATTRIBUTE4%TYPE := NULL,
52: ATTRIBUTE5 CS_CONTRACTS_ALL.ATTRIBUTE5%TYPE := NULL,
53: ATTRIBUTE6 CS_CONTRACTS_ALL.ATTRIBUTE6%TYPE := NULL,

Line 50: ATTRIBUTE3 CS_CONTRACTS_ALL.ATTRIBUTE3%TYPE := NULL,

46: TERMINATE_REASON_CODE CS_CONTRACTS_ALL.TERMINATE_REASON_CODE%TYPE := NULL,
47: DISCOUNT_ID CS_CONTRACTS_ALL.DISCOUNT_ID%TYPE := NULL,
48: ATTRIBUTE1 CS_CONTRACTS_ALL.ATTRIBUTE1%TYPE := NULL,
49: ATTRIBUTE2 CS_CONTRACTS_ALL.ATTRIBUTE2%TYPE := NULL,
50: ATTRIBUTE3 CS_CONTRACTS_ALL.ATTRIBUTE3%TYPE := NULL,
51: ATTRIBUTE4 CS_CONTRACTS_ALL.ATTRIBUTE4%TYPE := NULL,
52: ATTRIBUTE5 CS_CONTRACTS_ALL.ATTRIBUTE5%TYPE := NULL,
53: ATTRIBUTE6 CS_CONTRACTS_ALL.ATTRIBUTE6%TYPE := NULL,
54: ATTRIBUTE7 CS_CONTRACTS_ALL.ATTRIBUTE7%TYPE := NULL,

Line 51: ATTRIBUTE4 CS_CONTRACTS_ALL.ATTRIBUTE4%TYPE := NULL,

47: DISCOUNT_ID CS_CONTRACTS_ALL.DISCOUNT_ID%TYPE := NULL,
48: ATTRIBUTE1 CS_CONTRACTS_ALL.ATTRIBUTE1%TYPE := NULL,
49: ATTRIBUTE2 CS_CONTRACTS_ALL.ATTRIBUTE2%TYPE := NULL,
50: ATTRIBUTE3 CS_CONTRACTS_ALL.ATTRIBUTE3%TYPE := NULL,
51: ATTRIBUTE4 CS_CONTRACTS_ALL.ATTRIBUTE4%TYPE := NULL,
52: ATTRIBUTE5 CS_CONTRACTS_ALL.ATTRIBUTE5%TYPE := NULL,
53: ATTRIBUTE6 CS_CONTRACTS_ALL.ATTRIBUTE6%TYPE := NULL,
54: ATTRIBUTE7 CS_CONTRACTS_ALL.ATTRIBUTE7%TYPE := NULL,
55: ATTRIBUTE8 CS_CONTRACTS_ALL.ATTRIBUTE8%TYPE := NULL,

Line 52: ATTRIBUTE5 CS_CONTRACTS_ALL.ATTRIBUTE5%TYPE := NULL,

48: ATTRIBUTE1 CS_CONTRACTS_ALL.ATTRIBUTE1%TYPE := NULL,
49: ATTRIBUTE2 CS_CONTRACTS_ALL.ATTRIBUTE2%TYPE := NULL,
50: ATTRIBUTE3 CS_CONTRACTS_ALL.ATTRIBUTE3%TYPE := NULL,
51: ATTRIBUTE4 CS_CONTRACTS_ALL.ATTRIBUTE4%TYPE := NULL,
52: ATTRIBUTE5 CS_CONTRACTS_ALL.ATTRIBUTE5%TYPE := NULL,
53: ATTRIBUTE6 CS_CONTRACTS_ALL.ATTRIBUTE6%TYPE := NULL,
54: ATTRIBUTE7 CS_CONTRACTS_ALL.ATTRIBUTE7%TYPE := NULL,
55: ATTRIBUTE8 CS_CONTRACTS_ALL.ATTRIBUTE8%TYPE := NULL,
56: ATTRIBUTE9 CS_CONTRACTS_ALL.ATTRIBUTE9%TYPE := NULL,

Line 53: ATTRIBUTE6 CS_CONTRACTS_ALL.ATTRIBUTE6%TYPE := NULL,

49: ATTRIBUTE2 CS_CONTRACTS_ALL.ATTRIBUTE2%TYPE := NULL,
50: ATTRIBUTE3 CS_CONTRACTS_ALL.ATTRIBUTE3%TYPE := NULL,
51: ATTRIBUTE4 CS_CONTRACTS_ALL.ATTRIBUTE4%TYPE := NULL,
52: ATTRIBUTE5 CS_CONTRACTS_ALL.ATTRIBUTE5%TYPE := NULL,
53: ATTRIBUTE6 CS_CONTRACTS_ALL.ATTRIBUTE6%TYPE := NULL,
54: ATTRIBUTE7 CS_CONTRACTS_ALL.ATTRIBUTE7%TYPE := NULL,
55: ATTRIBUTE8 CS_CONTRACTS_ALL.ATTRIBUTE8%TYPE := NULL,
56: ATTRIBUTE9 CS_CONTRACTS_ALL.ATTRIBUTE9%TYPE := NULL,
57: ATTRIBUTE10 CS_CONTRACTS_ALL.ATTRIBUTE10%TYPE := NULL,

Line 54: ATTRIBUTE7 CS_CONTRACTS_ALL.ATTRIBUTE7%TYPE := NULL,

50: ATTRIBUTE3 CS_CONTRACTS_ALL.ATTRIBUTE3%TYPE := NULL,
51: ATTRIBUTE4 CS_CONTRACTS_ALL.ATTRIBUTE4%TYPE := NULL,
52: ATTRIBUTE5 CS_CONTRACTS_ALL.ATTRIBUTE5%TYPE := NULL,
53: ATTRIBUTE6 CS_CONTRACTS_ALL.ATTRIBUTE6%TYPE := NULL,
54: ATTRIBUTE7 CS_CONTRACTS_ALL.ATTRIBUTE7%TYPE := NULL,
55: ATTRIBUTE8 CS_CONTRACTS_ALL.ATTRIBUTE8%TYPE := NULL,
56: ATTRIBUTE9 CS_CONTRACTS_ALL.ATTRIBUTE9%TYPE := NULL,
57: ATTRIBUTE10 CS_CONTRACTS_ALL.ATTRIBUTE10%TYPE := NULL,
58: ATTRIBUTE11 CS_CONTRACTS_ALL.ATTRIBUTE11%TYPE := NULL,

Line 55: ATTRIBUTE8 CS_CONTRACTS_ALL.ATTRIBUTE8%TYPE := NULL,

51: ATTRIBUTE4 CS_CONTRACTS_ALL.ATTRIBUTE4%TYPE := NULL,
52: ATTRIBUTE5 CS_CONTRACTS_ALL.ATTRIBUTE5%TYPE := NULL,
53: ATTRIBUTE6 CS_CONTRACTS_ALL.ATTRIBUTE6%TYPE := NULL,
54: ATTRIBUTE7 CS_CONTRACTS_ALL.ATTRIBUTE7%TYPE := NULL,
55: ATTRIBUTE8 CS_CONTRACTS_ALL.ATTRIBUTE8%TYPE := NULL,
56: ATTRIBUTE9 CS_CONTRACTS_ALL.ATTRIBUTE9%TYPE := NULL,
57: ATTRIBUTE10 CS_CONTRACTS_ALL.ATTRIBUTE10%TYPE := NULL,
58: ATTRIBUTE11 CS_CONTRACTS_ALL.ATTRIBUTE11%TYPE := NULL,
59: ATTRIBUTE12 CS_CONTRACTS_ALL.ATTRIBUTE12%TYPE := NULL,

Line 56: ATTRIBUTE9 CS_CONTRACTS_ALL.ATTRIBUTE9%TYPE := NULL,

52: ATTRIBUTE5 CS_CONTRACTS_ALL.ATTRIBUTE5%TYPE := NULL,
53: ATTRIBUTE6 CS_CONTRACTS_ALL.ATTRIBUTE6%TYPE := NULL,
54: ATTRIBUTE7 CS_CONTRACTS_ALL.ATTRIBUTE7%TYPE := NULL,
55: ATTRIBUTE8 CS_CONTRACTS_ALL.ATTRIBUTE8%TYPE := NULL,
56: ATTRIBUTE9 CS_CONTRACTS_ALL.ATTRIBUTE9%TYPE := NULL,
57: ATTRIBUTE10 CS_CONTRACTS_ALL.ATTRIBUTE10%TYPE := NULL,
58: ATTRIBUTE11 CS_CONTRACTS_ALL.ATTRIBUTE11%TYPE := NULL,
59: ATTRIBUTE12 CS_CONTRACTS_ALL.ATTRIBUTE12%TYPE := NULL,
60: ATTRIBUTE13 CS_CONTRACTS_ALL.ATTRIBUTE13%TYPE := NULL,

Line 57: ATTRIBUTE10 CS_CONTRACTS_ALL.ATTRIBUTE10%TYPE := NULL,

53: ATTRIBUTE6 CS_CONTRACTS_ALL.ATTRIBUTE6%TYPE := NULL,
54: ATTRIBUTE7 CS_CONTRACTS_ALL.ATTRIBUTE7%TYPE := NULL,
55: ATTRIBUTE8 CS_CONTRACTS_ALL.ATTRIBUTE8%TYPE := NULL,
56: ATTRIBUTE9 CS_CONTRACTS_ALL.ATTRIBUTE9%TYPE := NULL,
57: ATTRIBUTE10 CS_CONTRACTS_ALL.ATTRIBUTE10%TYPE := NULL,
58: ATTRIBUTE11 CS_CONTRACTS_ALL.ATTRIBUTE11%TYPE := NULL,
59: ATTRIBUTE12 CS_CONTRACTS_ALL.ATTRIBUTE12%TYPE := NULL,
60: ATTRIBUTE13 CS_CONTRACTS_ALL.ATTRIBUTE13%TYPE := NULL,
61: ATTRIBUTE14 CS_CONTRACTS_ALL.ATTRIBUTE14%TYPE := NULL,

Line 58: ATTRIBUTE11 CS_CONTRACTS_ALL.ATTRIBUTE11%TYPE := NULL,

54: ATTRIBUTE7 CS_CONTRACTS_ALL.ATTRIBUTE7%TYPE := NULL,
55: ATTRIBUTE8 CS_CONTRACTS_ALL.ATTRIBUTE8%TYPE := NULL,
56: ATTRIBUTE9 CS_CONTRACTS_ALL.ATTRIBUTE9%TYPE := NULL,
57: ATTRIBUTE10 CS_CONTRACTS_ALL.ATTRIBUTE10%TYPE := NULL,
58: ATTRIBUTE11 CS_CONTRACTS_ALL.ATTRIBUTE11%TYPE := NULL,
59: ATTRIBUTE12 CS_CONTRACTS_ALL.ATTRIBUTE12%TYPE := NULL,
60: ATTRIBUTE13 CS_CONTRACTS_ALL.ATTRIBUTE13%TYPE := NULL,
61: ATTRIBUTE14 CS_CONTRACTS_ALL.ATTRIBUTE14%TYPE := NULL,
62: ATTRIBUTE15 CS_CONTRACTS_ALL.ATTRIBUTE15%TYPE := NULL,

Line 59: ATTRIBUTE12 CS_CONTRACTS_ALL.ATTRIBUTE12%TYPE := NULL,

55: ATTRIBUTE8 CS_CONTRACTS_ALL.ATTRIBUTE8%TYPE := NULL,
56: ATTRIBUTE9 CS_CONTRACTS_ALL.ATTRIBUTE9%TYPE := NULL,
57: ATTRIBUTE10 CS_CONTRACTS_ALL.ATTRIBUTE10%TYPE := NULL,
58: ATTRIBUTE11 CS_CONTRACTS_ALL.ATTRIBUTE11%TYPE := NULL,
59: ATTRIBUTE12 CS_CONTRACTS_ALL.ATTRIBUTE12%TYPE := NULL,
60: ATTRIBUTE13 CS_CONTRACTS_ALL.ATTRIBUTE13%TYPE := NULL,
61: ATTRIBUTE14 CS_CONTRACTS_ALL.ATTRIBUTE14%TYPE := NULL,
62: ATTRIBUTE15 CS_CONTRACTS_ALL.ATTRIBUTE15%TYPE := NULL,
63: CONTEXT CS_CONTRACTS_ALL.CONTEXT%TYPE := NULL,

Line 60: ATTRIBUTE13 CS_CONTRACTS_ALL.ATTRIBUTE13%TYPE := NULL,

56: ATTRIBUTE9 CS_CONTRACTS_ALL.ATTRIBUTE9%TYPE := NULL,
57: ATTRIBUTE10 CS_CONTRACTS_ALL.ATTRIBUTE10%TYPE := NULL,
58: ATTRIBUTE11 CS_CONTRACTS_ALL.ATTRIBUTE11%TYPE := NULL,
59: ATTRIBUTE12 CS_CONTRACTS_ALL.ATTRIBUTE12%TYPE := NULL,
60: ATTRIBUTE13 CS_CONTRACTS_ALL.ATTRIBUTE13%TYPE := NULL,
61: ATTRIBUTE14 CS_CONTRACTS_ALL.ATTRIBUTE14%TYPE := NULL,
62: ATTRIBUTE15 CS_CONTRACTS_ALL.ATTRIBUTE15%TYPE := NULL,
63: CONTEXT CS_CONTRACTS_ALL.CONTEXT%TYPE := NULL,
64: OBJECT_VERSION_NUMBER CS_CONTRACTS_ALL.OBJECT_VERSION_NUMBER%TYPE := NULL,

Line 61: ATTRIBUTE14 CS_CONTRACTS_ALL.ATTRIBUTE14%TYPE := NULL,

57: ATTRIBUTE10 CS_CONTRACTS_ALL.ATTRIBUTE10%TYPE := NULL,
58: ATTRIBUTE11 CS_CONTRACTS_ALL.ATTRIBUTE11%TYPE := NULL,
59: ATTRIBUTE12 CS_CONTRACTS_ALL.ATTRIBUTE12%TYPE := NULL,
60: ATTRIBUTE13 CS_CONTRACTS_ALL.ATTRIBUTE13%TYPE := NULL,
61: ATTRIBUTE14 CS_CONTRACTS_ALL.ATTRIBUTE14%TYPE := NULL,
62: ATTRIBUTE15 CS_CONTRACTS_ALL.ATTRIBUTE15%TYPE := NULL,
63: CONTEXT CS_CONTRACTS_ALL.CONTEXT%TYPE := NULL,
64: OBJECT_VERSION_NUMBER CS_CONTRACTS_ALL.OBJECT_VERSION_NUMBER%TYPE := NULL,
65: PO_REQUIRED_TO_SERVICE CS_CONTRACTS_ALL.PO_REQUIRED_TO_SERVICE%TYPE := NULL,

Line 62: ATTRIBUTE15 CS_CONTRACTS_ALL.ATTRIBUTE15%TYPE := NULL,

58: ATTRIBUTE11 CS_CONTRACTS_ALL.ATTRIBUTE11%TYPE := NULL,
59: ATTRIBUTE12 CS_CONTRACTS_ALL.ATTRIBUTE12%TYPE := NULL,
60: ATTRIBUTE13 CS_CONTRACTS_ALL.ATTRIBUTE13%TYPE := NULL,
61: ATTRIBUTE14 CS_CONTRACTS_ALL.ATTRIBUTE14%TYPE := NULL,
62: ATTRIBUTE15 CS_CONTRACTS_ALL.ATTRIBUTE15%TYPE := NULL,
63: CONTEXT CS_CONTRACTS_ALL.CONTEXT%TYPE := NULL,
64: OBJECT_VERSION_NUMBER CS_CONTRACTS_ALL.OBJECT_VERSION_NUMBER%TYPE := NULL,
65: PO_REQUIRED_TO_SERVICE CS_CONTRACTS_ALL.PO_REQUIRED_TO_SERVICE%TYPE := NULL,
66: PRE_PAYMENT_REQUIRED CS_CONTRACTS_ALL.PRE_PAYMENT_REQUIRED%TYPE := NULL );

Line 63: CONTEXT CS_CONTRACTS_ALL.CONTEXT%TYPE := NULL,

59: ATTRIBUTE12 CS_CONTRACTS_ALL.ATTRIBUTE12%TYPE := NULL,
60: ATTRIBUTE13 CS_CONTRACTS_ALL.ATTRIBUTE13%TYPE := NULL,
61: ATTRIBUTE14 CS_CONTRACTS_ALL.ATTRIBUTE14%TYPE := NULL,
62: ATTRIBUTE15 CS_CONTRACTS_ALL.ATTRIBUTE15%TYPE := NULL,
63: CONTEXT CS_CONTRACTS_ALL.CONTEXT%TYPE := NULL,
64: OBJECT_VERSION_NUMBER CS_CONTRACTS_ALL.OBJECT_VERSION_NUMBER%TYPE := NULL,
65: PO_REQUIRED_TO_SERVICE CS_CONTRACTS_ALL.PO_REQUIRED_TO_SERVICE%TYPE := NULL,
66: PRE_PAYMENT_REQUIRED CS_CONTRACTS_ALL.PRE_PAYMENT_REQUIRED%TYPE := NULL );
67: G_MISS_rcontract_rec RContract_Rec_Type;

Line 64: OBJECT_VERSION_NUMBER CS_CONTRACTS_ALL.OBJECT_VERSION_NUMBER%TYPE := NULL,

60: ATTRIBUTE13 CS_CONTRACTS_ALL.ATTRIBUTE13%TYPE := NULL,
61: ATTRIBUTE14 CS_CONTRACTS_ALL.ATTRIBUTE14%TYPE := NULL,
62: ATTRIBUTE15 CS_CONTRACTS_ALL.ATTRIBUTE15%TYPE := NULL,
63: CONTEXT CS_CONTRACTS_ALL.CONTEXT%TYPE := NULL,
64: OBJECT_VERSION_NUMBER CS_CONTRACTS_ALL.OBJECT_VERSION_NUMBER%TYPE := NULL,
65: PO_REQUIRED_TO_SERVICE CS_CONTRACTS_ALL.PO_REQUIRED_TO_SERVICE%TYPE := NULL,
66: PRE_PAYMENT_REQUIRED CS_CONTRACTS_ALL.PRE_PAYMENT_REQUIRED%TYPE := NULL );
67: G_MISS_rcontract_rec RContract_Rec_Type;
68:

Line 65: PO_REQUIRED_TO_SERVICE CS_CONTRACTS_ALL.PO_REQUIRED_TO_SERVICE%TYPE := NULL,

61: ATTRIBUTE14 CS_CONTRACTS_ALL.ATTRIBUTE14%TYPE := NULL,
62: ATTRIBUTE15 CS_CONTRACTS_ALL.ATTRIBUTE15%TYPE := NULL,
63: CONTEXT CS_CONTRACTS_ALL.CONTEXT%TYPE := NULL,
64: OBJECT_VERSION_NUMBER CS_CONTRACTS_ALL.OBJECT_VERSION_NUMBER%TYPE := NULL,
65: PO_REQUIRED_TO_SERVICE CS_CONTRACTS_ALL.PO_REQUIRED_TO_SERVICE%TYPE := NULL,
66: PRE_PAYMENT_REQUIRED CS_CONTRACTS_ALL.PRE_PAYMENT_REQUIRED%TYPE := NULL );
67: G_MISS_rcontract_rec RContract_Rec_Type;
68:
69:

Line 66: PRE_PAYMENT_REQUIRED CS_CONTRACTS_ALL.PRE_PAYMENT_REQUIRED%TYPE := NULL );

62: ATTRIBUTE15 CS_CONTRACTS_ALL.ATTRIBUTE15%TYPE := NULL,
63: CONTEXT CS_CONTRACTS_ALL.CONTEXT%TYPE := NULL,
64: OBJECT_VERSION_NUMBER CS_CONTRACTS_ALL.OBJECT_VERSION_NUMBER%TYPE := NULL,
65: PO_REQUIRED_TO_SERVICE CS_CONTRACTS_ALL.PO_REQUIRED_TO_SERVICE%TYPE := NULL,
66: PRE_PAYMENT_REQUIRED CS_CONTRACTS_ALL.PRE_PAYMENT_REQUIRED%TYPE := NULL );
67: G_MISS_rcontract_rec RContract_Rec_Type;
68:
69:
70: PROCEDURE Populate_Contracts(p_from IN RContract_Rec_Type ,

Line 261: FROM CS_CONTRACTS

257: CONTEXT ,
258: OBJECT_VERSION_NUMBER ,
259: PO_REQUIRED_TO_SERVICE ,
260: PRE_PAYMENT_REQUIRED
261: FROM CS_CONTRACTS
262: where exp_term_date < cs_contracts.end_date_active
263: AND cs_contracts.next_bill_date IS NULL;
264:
265:

Line 262: where exp_term_date < cs_contracts.end_date_active

258: OBJECT_VERSION_NUMBER ,
259: PO_REQUIRED_TO_SERVICE ,
260: PRE_PAYMENT_REQUIRED
261: FROM CS_CONTRACTS
262: where exp_term_date < cs_contracts.end_date_active
263: AND cs_contracts.next_bill_date IS NULL;
264:
265:
266:

Line 263: AND cs_contracts.next_bill_date IS NULL;

259: PO_REQUIRED_TO_SERVICE ,
260: PRE_PAYMENT_REQUIRED
261: FROM CS_CONTRACTS
262: where exp_term_date < cs_contracts.end_date_active
263: AND cs_contracts.next_bill_date IS NULL;
264:
265:
266:
267:

Line 289: v_status_id := FND_PROFILE.VALUE('CS_CONTRACTS_EXPIRED_STATUS');

285: and cs_cp_services_all.cp_service_id = cs_cp_service_transactions.cp_service_id;
286:
287:
288: IF v_counter = 0 THEN
289: v_status_id := FND_PROFILE.VALUE('CS_CONTRACTS_EXPIRED_STATUS');
290: else
291: v_status_id := FND_PROFILE.VALUE('CS_CONTRACTS_TERMINATED_STATUS');
292: END IF;
293:

Line 291: v_status_id := FND_PROFILE.VALUE('CS_CONTRACTS_TERMINATED_STATUS');

287:
288: IF v_counter = 0 THEN
289: v_status_id := FND_PROFILE.VALUE('CS_CONTRACTS_EXPIRED_STATUS');
290: else
291: v_status_id := FND_PROFILE.VALUE('CS_CONTRACTS_TERMINATED_STATUS');
292: END IF;
293:
294:
295: IF v_status_id IS NULL THEN