APPS.CS_CONTRACTS_PUB dependencies on CS_CONTRACTS

Line 1: PACKAGE BODY CS_CONTRACTS_PUB AS

1: PACKAGE BODY CS_CONTRACTS_PUB AS
2: /* $Header: csctpapb.pls 115.11 99/07/16 08:53:07 porting ship $ */
3: ----------------------------------------------------------------------------
4: -- GLOBAL CONSTANTS
5: ----------------------------------------------------------------------------

Line 12: G_NO_CHILDREN_MSG CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_NO_CHILDREN';

8: -- GLOBAL MESSAGES
9: ----------------------------------------------------------------------------
10: -- Message for NO_CHILDREN should be something like:
11: -- "Invalid record for: PARENT_TABLE. No children exist in CHILD_TABLE"
12: G_NO_CHILDREN_MSG CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_NO_CHILDREN';
13: G_SERVICE_ATTACHED_TO_TEMPLATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_SVC_ATT_TEMPLATE';
14: G_INCOMPATIBLE_CONTRACT_LEVELS CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INCMPTBL_COV_LVLS';
15: G_VALIDATION_SUCCESSFUL CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_VAL_SUCCESS';
16: G_COVERAGE_OVERLAP CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_COVERAGE_OVERLAP';

Line 13: G_SERVICE_ATTACHED_TO_TEMPLATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_SVC_ATT_TEMPLATE';

9: ----------------------------------------------------------------------------
10: -- Message for NO_CHILDREN should be something like:
11: -- "Invalid record for: PARENT_TABLE. No children exist in CHILD_TABLE"
12: G_NO_CHILDREN_MSG CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_NO_CHILDREN';
13: G_SERVICE_ATTACHED_TO_TEMPLATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_SVC_ATT_TEMPLATE';
14: G_INCOMPATIBLE_CONTRACT_LEVELS CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INCMPTBL_COV_LVLS';
15: G_VALIDATION_SUCCESSFUL CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_VAL_SUCCESS';
16: G_COVERAGE_OVERLAP CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_COVERAGE_OVERLAP';
17: G_INVALID_SERVICE_START_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_SVC_START_DT';

Line 14: G_INCOMPATIBLE_CONTRACT_LEVELS CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INCMPTBL_COV_LVLS';

10: -- Message for NO_CHILDREN should be something like:
11: -- "Invalid record for: PARENT_TABLE. No children exist in CHILD_TABLE"
12: G_NO_CHILDREN_MSG CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_NO_CHILDREN';
13: G_SERVICE_ATTACHED_TO_TEMPLATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_SVC_ATT_TEMPLATE';
14: G_INCOMPATIBLE_CONTRACT_LEVELS CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INCMPTBL_COV_LVLS';
15: G_VALIDATION_SUCCESSFUL CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_VAL_SUCCESS';
16: G_COVERAGE_OVERLAP CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_COVERAGE_OVERLAP';
17: G_INVALID_SERVICE_START_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_SVC_START_DT';
18: G_INVALID_SERVICE_END_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_SVC_END_DT';

Line 15: G_VALIDATION_SUCCESSFUL CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_VAL_SUCCESS';

11: -- "Invalid record for: PARENT_TABLE. No children exist in CHILD_TABLE"
12: G_NO_CHILDREN_MSG CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_NO_CHILDREN';
13: G_SERVICE_ATTACHED_TO_TEMPLATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_SVC_ATT_TEMPLATE';
14: G_INCOMPATIBLE_CONTRACT_LEVELS CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INCMPTBL_COV_LVLS';
15: G_VALIDATION_SUCCESSFUL CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_VAL_SUCCESS';
16: G_COVERAGE_OVERLAP CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_COVERAGE_OVERLAP';
17: G_INVALID_SERVICE_START_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_SVC_START_DT';
18: G_INVALID_SERVICE_END_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_SVC_END_DT';
19: G_INVALID_TXN_GRP_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_TXNGRP_DT';

Line 16: G_COVERAGE_OVERLAP CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_COVERAGE_OVERLAP';

12: G_NO_CHILDREN_MSG CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_NO_CHILDREN';
13: G_SERVICE_ATTACHED_TO_TEMPLATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_SVC_ATT_TEMPLATE';
14: G_INCOMPATIBLE_CONTRACT_LEVELS CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INCMPTBL_COV_LVLS';
15: G_VALIDATION_SUCCESSFUL CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_VAL_SUCCESS';
16: G_COVERAGE_OVERLAP CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_COVERAGE_OVERLAP';
17: G_INVALID_SERVICE_START_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_SVC_START_DT';
18: G_INVALID_SERVICE_END_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_SVC_END_DT';
19: G_INVALID_TXN_GRP_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_TXNGRP_DT';
20: G_TXN_GRP_DATE_TOKEN CONSTANT VARCHAR2(200) := 'DATE1';

Line 17: G_INVALID_SERVICE_START_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_SVC_START_DT';

13: G_SERVICE_ATTACHED_TO_TEMPLATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_SVC_ATT_TEMPLATE';
14: G_INCOMPATIBLE_CONTRACT_LEVELS CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INCMPTBL_COV_LVLS';
15: G_VALIDATION_SUCCESSFUL CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_VAL_SUCCESS';
16: G_COVERAGE_OVERLAP CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_COVERAGE_OVERLAP';
17: G_INVALID_SERVICE_START_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_SVC_START_DT';
18: G_INVALID_SERVICE_END_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_SVC_END_DT';
19: G_INVALID_TXN_GRP_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_TXNGRP_DT';
20: G_TXN_GRP_DATE_TOKEN CONSTANT VARCHAR2(200) := 'DATE1';
21: G_COV_START_DATE_TOKEN CONSTANT VARCHAR2(200) := 'DATE2';

Line 18: G_INVALID_SERVICE_END_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_SVC_END_DT';

14: G_INCOMPATIBLE_CONTRACT_LEVELS CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INCMPTBL_COV_LVLS';
15: G_VALIDATION_SUCCESSFUL CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_VAL_SUCCESS';
16: G_COVERAGE_OVERLAP CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_COVERAGE_OVERLAP';
17: G_INVALID_SERVICE_START_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_SVC_START_DT';
18: G_INVALID_SERVICE_END_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_SVC_END_DT';
19: G_INVALID_TXN_GRP_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_TXNGRP_DT';
20: G_TXN_GRP_DATE_TOKEN CONSTANT VARCHAR2(200) := 'DATE1';
21: G_COV_START_DATE_TOKEN CONSTANT VARCHAR2(200) := 'DATE2';
22: G_COV_END_DATE_TOKEN CONSTANT VARCHAR2(200) := 'DATE3';

Line 19: G_INVALID_TXN_GRP_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_TXNGRP_DT';

15: G_VALIDATION_SUCCESSFUL CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_VAL_SUCCESS';
16: G_COVERAGE_OVERLAP CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_COVERAGE_OVERLAP';
17: G_INVALID_SERVICE_START_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_SVC_START_DT';
18: G_INVALID_SERVICE_END_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_SVC_END_DT';
19: G_INVALID_TXN_GRP_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_TXNGRP_DT';
20: G_TXN_GRP_DATE_TOKEN CONSTANT VARCHAR2(200) := 'DATE1';
21: G_COV_START_DATE_TOKEN CONSTANT VARCHAR2(200) := 'DATE2';
22: G_COV_END_DATE_TOKEN CONSTANT VARCHAR2(200) := 'DATE3';
23: G_MISMATCH_COV_SERVICE_DATES CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_SVC_COV_DT';

Line 23: G_MISMATCH_COV_SERVICE_DATES CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_SVC_COV_DT';

19: G_INVALID_TXN_GRP_DATE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_TXNGRP_DT';
20: G_TXN_GRP_DATE_TOKEN CONSTANT VARCHAR2(200) := 'DATE1';
21: G_COV_START_DATE_TOKEN CONSTANT VARCHAR2(200) := 'DATE2';
22: G_COV_END_DATE_TOKEN CONSTANT VARCHAR2(200) := 'DATE3';
23: G_MISMATCH_COV_SERVICE_DATES CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVD_SVC_COV_DT';
24: G_COVERAGE_START_DATE_TOKEN CONSTANT VARCHAR2(200) := 'DATE1';
25: G_COVERAGE_END_DATE_TOKEN CONSTANT VARCHAR2(200) := 'DATE2';
26: G_SVC_START_DATE_TOKEN CONSTANT VARCHAR2(200) := 'DATE3';
27: G_SVC_END_DATE_TOKEN CONSTANT VARCHAR2(200) := 'DATE4';

Line 69: p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE

65: --------------------------------------------------------------------------------
66: -- FUNCTION populate_contract_rec
67: --------------------------------------------------------------------------------
68: FUNCTION populate_contract_rec (
69: p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE
70: ) RETURN Contract_Rec_Type IS
71: CURSOR get_contract_rec (p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE) IS
72: SELECT *
73: FROM cs_contracts_all

Line 71: CURSOR get_contract_rec (p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE) IS

67: --------------------------------------------------------------------------------
68: FUNCTION populate_contract_rec (
69: p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE
70: ) RETURN Contract_Rec_Type IS
71: CURSOR get_contract_rec (p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE) IS
72: SELECT *
73: FROM cs_contracts_all
74: WHERE contract_id = p_contract_id;
75:

Line 73: FROM cs_contracts_all

69: p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE
70: ) RETURN Contract_Rec_Type IS
71: CURSOR get_contract_rec (p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE) IS
72: SELECT *
73: FROM cs_contracts_all
74: WHERE contract_id = p_contract_id;
75:
76: l_contract_rec Contract_Rec_Type;
77: l_no_data_found BOOLEAN := TRUE;

Line 418: CURSOR chk_csr (p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE) IS

414: l_index NUMBER := 0;
415: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
416: l_return_error_exc EXCEPTION;
417:
418: CURSOR chk_csr (p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE) IS
419: SELECT *
420: FROM cs_cp_services_all
421: WHERE contract_id = p_contract_id;
422:

Line 438: -- CS_CONTRACTS_ALL then give a warning.

434: -- Check FIRST_BILL_DATE and BILLING_FREQUENCY_PERIOD are NOT NULL.
435: -- While the 2 columns are allowed to be NULL in CS_CP_SERVICES_ALL,
436: -- the columns should not be NULL for a contract.
437: -- If the fields are null in CS_CP_SERVICES_ALL, as well as
438: -- CS_CONTRACTS_ALL then give a warning.
439: ----------------------------------------------------------------------
440: IF ((p_services_all_rec.FIRST_BILL_DATE IS NULL)
441: AND (p_contract_rec.FIRST_BILL_DATE IS NULL)) THEN
442: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

Line 518: -- START and END dates of CS_CONTRACTS

514: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
515: l_return_error_exc EXCEPTION;
516: BEGIN
517: -- Validate START and END dates of the service fall within the
518: -- START and END dates of CS_CONTRACTS
519: IF (p_services_rec.start_date_active < p_contract_rec.start_date_active) THEN
520: FND_MESSAGE.set_name(G_APP_NAME, G_INVALID_SERVICE_START_DATE);
521: RAISE l_return_error_exc;
522: ELSIF (p_services_rec.end_date_active > p_contract_rec.end_date_active) THEN

Line 538: set_msg_no_children('CS_CONTRACTS_ALL', 'CS_CP_SERVICES_ALL');

534: FOR l_csr_rec IN chk_csr(p_contract_rec.contract_id) LOOP
535: l_services_all_tbl(chk_csr%ROWCOUNT) := l_csr_rec;
536: END LOOP;
537: IF (l_services_all_tbl.COUNT = 0) THEN
538: set_msg_no_children('CS_CONTRACTS_ALL', 'CS_CP_SERVICES_ALL');
539: l_return_status := FND_API.G_RET_STS_ERROR;
540: RAISE l_return_error_exc;
541: END IF;
542:

Line 555: -- START and END dates of CS_CONTRACTS

551: RAISE l_return_error_exc;
552: END IF;
553: --------------------------------------------------------------
554: -- Validate START and END dates of the service fall within the
555: -- START and END dates of CS_CONTRACTS
556: --------------------------------------------------------------
557: l_return_status := val_start_end_dates(l_services_all_tbl(l_index), p_contract_rec);
558: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
559: RAISE l_return_error_exc;

Line 691: p_contract_id IN CS_CONTRACTS.CONTRACT_ID%TYPE

687: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
688: x_return_status OUT VARCHAR2,
689: x_msg_count OUT NUMBER,
690: x_msg_data OUT VARCHAR2,
691: p_contract_id IN CS_CONTRACTS.CONTRACT_ID%TYPE
692: -- COMMENTED OUT 17-SEP-98 DEVELOPER/2000 FORMS uses PL/SQL 1.6 which cannot
693: -- handle selective parameter passing
694: -- p_contract_number IN CS_CONTRACTS.CONTRACT_NUMBER%TYPE := NULL,
695: -- p_workflow IN CS_CONTRACTS.WORKFLOW%TYPE := NULL,

Line 694: -- p_contract_number IN CS_CONTRACTS.CONTRACT_NUMBER%TYPE := NULL,

690: x_msg_data OUT VARCHAR2,
691: p_contract_id IN CS_CONTRACTS.CONTRACT_ID%TYPE
692: -- COMMENTED OUT 17-SEP-98 DEVELOPER/2000 FORMS uses PL/SQL 1.6 which cannot
693: -- handle selective parameter passing
694: -- p_contract_number IN CS_CONTRACTS.CONTRACT_NUMBER%TYPE := NULL,
695: -- p_workflow IN CS_CONTRACTS.WORKFLOW%TYPE := NULL,
696: -- p_agreement_id IN CS_CONTRACTS.AGREEMENT_ID%TYPE := NULL,
697: -- p_price_list_id IN CS_CONTRACTS.PRICE_LIST_ID%TYPE := NULL,
698: -- p_currency_code IN CS_CONTRACTS.CURRENCY_CODE%TYPE := NULL,

Line 695: -- p_workflow IN CS_CONTRACTS.WORKFLOW%TYPE := NULL,

691: p_contract_id IN CS_CONTRACTS.CONTRACT_ID%TYPE
692: -- COMMENTED OUT 17-SEP-98 DEVELOPER/2000 FORMS uses PL/SQL 1.6 which cannot
693: -- handle selective parameter passing
694: -- p_contract_number IN CS_CONTRACTS.CONTRACT_NUMBER%TYPE := NULL,
695: -- p_workflow IN CS_CONTRACTS.WORKFLOW%TYPE := NULL,
696: -- p_agreement_id IN CS_CONTRACTS.AGREEMENT_ID%TYPE := NULL,
697: -- p_price_list_id IN CS_CONTRACTS.PRICE_LIST_ID%TYPE := NULL,
698: -- p_currency_code IN CS_CONTRACTS.CURRENCY_CODE%TYPE := NULL,
699: -- p_conversion_type_code IN CS_CONTRACTS.CONVERSION_TYPE_CODE%TYPE := NULL,

Line 696: -- p_agreement_id IN CS_CONTRACTS.AGREEMENT_ID%TYPE := NULL,

692: -- COMMENTED OUT 17-SEP-98 DEVELOPER/2000 FORMS uses PL/SQL 1.6 which cannot
693: -- handle selective parameter passing
694: -- p_contract_number IN CS_CONTRACTS.CONTRACT_NUMBER%TYPE := NULL,
695: -- p_workflow IN CS_CONTRACTS.WORKFLOW%TYPE := NULL,
696: -- p_agreement_id IN CS_CONTRACTS.AGREEMENT_ID%TYPE := NULL,
697: -- p_price_list_id IN CS_CONTRACTS.PRICE_LIST_ID%TYPE := NULL,
698: -- p_currency_code IN CS_CONTRACTS.CURRENCY_CODE%TYPE := NULL,
699: -- p_conversion_type_code IN CS_CONTRACTS.CONVERSION_TYPE_CODE%TYPE := NULL,
700: -- p_conversion_rate IN CS_CONTRACTS.CONVERSION_RATE%TYPE := NULL,

Line 697: -- p_price_list_id IN CS_CONTRACTS.PRICE_LIST_ID%TYPE := NULL,

693: -- handle selective parameter passing
694: -- p_contract_number IN CS_CONTRACTS.CONTRACT_NUMBER%TYPE := NULL,
695: -- p_workflow IN CS_CONTRACTS.WORKFLOW%TYPE := NULL,
696: -- p_agreement_id IN CS_CONTRACTS.AGREEMENT_ID%TYPE := NULL,
697: -- p_price_list_id IN CS_CONTRACTS.PRICE_LIST_ID%TYPE := NULL,
698: -- p_currency_code IN CS_CONTRACTS.CURRENCY_CODE%TYPE := NULL,
699: -- p_conversion_type_code IN CS_CONTRACTS.CONVERSION_TYPE_CODE%TYPE := NULL,
700: -- p_conversion_rate IN CS_CONTRACTS.CONVERSION_RATE%TYPE := NULL,
701: -- p_conversion_date IN CS_CONTRACTS.CONVERSION_DATE%TYPE := NULL,

Line 698: -- p_currency_code IN CS_CONTRACTS.CURRENCY_CODE%TYPE := NULL,

694: -- p_contract_number IN CS_CONTRACTS.CONTRACT_NUMBER%TYPE := NULL,
695: -- p_workflow IN CS_CONTRACTS.WORKFLOW%TYPE := NULL,
696: -- p_agreement_id IN CS_CONTRACTS.AGREEMENT_ID%TYPE := NULL,
697: -- p_price_list_id IN CS_CONTRACTS.PRICE_LIST_ID%TYPE := NULL,
698: -- p_currency_code IN CS_CONTRACTS.CURRENCY_CODE%TYPE := NULL,
699: -- p_conversion_type_code IN CS_CONTRACTS.CONVERSION_TYPE_CODE%TYPE := NULL,
700: -- p_conversion_rate IN CS_CONTRACTS.CONVERSION_RATE%TYPE := NULL,
701: -- p_conversion_date IN CS_CONTRACTS.CONVERSION_DATE%TYPE := NULL,
702: -- p_invoicing_rule_id IN CS_CONTRACTS.INVOICING_RULE_ID%TYPE := NULL,

Line 699: -- p_conversion_type_code IN CS_CONTRACTS.CONVERSION_TYPE_CODE%TYPE := NULL,

695: -- p_workflow IN CS_CONTRACTS.WORKFLOW%TYPE := NULL,
696: -- p_agreement_id IN CS_CONTRACTS.AGREEMENT_ID%TYPE := NULL,
697: -- p_price_list_id IN CS_CONTRACTS.PRICE_LIST_ID%TYPE := NULL,
698: -- p_currency_code IN CS_CONTRACTS.CURRENCY_CODE%TYPE := NULL,
699: -- p_conversion_type_code IN CS_CONTRACTS.CONVERSION_TYPE_CODE%TYPE := NULL,
700: -- p_conversion_rate IN CS_CONTRACTS.CONVERSION_RATE%TYPE := NULL,
701: -- p_conversion_date IN CS_CONTRACTS.CONVERSION_DATE%TYPE := NULL,
702: -- p_invoicing_rule_id IN CS_CONTRACTS.INVOICING_RULE_ID%TYPE := NULL,
703: -- p_accounting_rule_id IN CS_CONTRACTS.ACCOUNTING_RULE_ID%TYPE := NULL,

Line 700: -- p_conversion_rate IN CS_CONTRACTS.CONVERSION_RATE%TYPE := NULL,

696: -- p_agreement_id IN CS_CONTRACTS.AGREEMENT_ID%TYPE := NULL,
697: -- p_price_list_id IN CS_CONTRACTS.PRICE_LIST_ID%TYPE := NULL,
698: -- p_currency_code IN CS_CONTRACTS.CURRENCY_CODE%TYPE := NULL,
699: -- p_conversion_type_code IN CS_CONTRACTS.CONVERSION_TYPE_CODE%TYPE := NULL,
700: -- p_conversion_rate IN CS_CONTRACTS.CONVERSION_RATE%TYPE := NULL,
701: -- p_conversion_date IN CS_CONTRACTS.CONVERSION_DATE%TYPE := NULL,
702: -- p_invoicing_rule_id IN CS_CONTRACTS.INVOICING_RULE_ID%TYPE := NULL,
703: -- p_accounting_rule_id IN CS_CONTRACTS.ACCOUNTING_RULE_ID%TYPE := NULL,
704: -- p_billing_frequency_period IN CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := NULL,

Line 701: -- p_conversion_date IN CS_CONTRACTS.CONVERSION_DATE%TYPE := NULL,

697: -- p_price_list_id IN CS_CONTRACTS.PRICE_LIST_ID%TYPE := NULL,
698: -- p_currency_code IN CS_CONTRACTS.CURRENCY_CODE%TYPE := NULL,
699: -- p_conversion_type_code IN CS_CONTRACTS.CONVERSION_TYPE_CODE%TYPE := NULL,
700: -- p_conversion_rate IN CS_CONTRACTS.CONVERSION_RATE%TYPE := NULL,
701: -- p_conversion_date IN CS_CONTRACTS.CONVERSION_DATE%TYPE := NULL,
702: -- p_invoicing_rule_id IN CS_CONTRACTS.INVOICING_RULE_ID%TYPE := NULL,
703: -- p_accounting_rule_id IN CS_CONTRACTS.ACCOUNTING_RULE_ID%TYPE := NULL,
704: -- p_billing_frequency_period IN CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
705: -- p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := NULL,

Line 702: -- p_invoicing_rule_id IN CS_CONTRACTS.INVOICING_RULE_ID%TYPE := NULL,

698: -- p_currency_code IN CS_CONTRACTS.CURRENCY_CODE%TYPE := NULL,
699: -- p_conversion_type_code IN CS_CONTRACTS.CONVERSION_TYPE_CODE%TYPE := NULL,
700: -- p_conversion_rate IN CS_CONTRACTS.CONVERSION_RATE%TYPE := NULL,
701: -- p_conversion_date IN CS_CONTRACTS.CONVERSION_DATE%TYPE := NULL,
702: -- p_invoicing_rule_id IN CS_CONTRACTS.INVOICING_RULE_ID%TYPE := NULL,
703: -- p_accounting_rule_id IN CS_CONTRACTS.ACCOUNTING_RULE_ID%TYPE := NULL,
704: -- p_billing_frequency_period IN CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
705: -- p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := NULL,
706: -- p_next_bill_date IN CS_CONTRACTS.NEXT_BILL_DATE%TYPE := NULL,

Line 703: -- p_accounting_rule_id IN CS_CONTRACTS.ACCOUNTING_RULE_ID%TYPE := NULL,

699: -- p_conversion_type_code IN CS_CONTRACTS.CONVERSION_TYPE_CODE%TYPE := NULL,
700: -- p_conversion_rate IN CS_CONTRACTS.CONVERSION_RATE%TYPE := NULL,
701: -- p_conversion_date IN CS_CONTRACTS.CONVERSION_DATE%TYPE := NULL,
702: -- p_invoicing_rule_id IN CS_CONTRACTS.INVOICING_RULE_ID%TYPE := NULL,
703: -- p_accounting_rule_id IN CS_CONTRACTS.ACCOUNTING_RULE_ID%TYPE := NULL,
704: -- p_billing_frequency_period IN CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
705: -- p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := NULL,
706: -- p_next_bill_date IN CS_CONTRACTS.NEXT_BILL_DATE%TYPE := NULL,
707: -- p_create_sales_order IN CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := NULL,

Line 704: -- p_billing_frequency_period IN CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := NULL,

700: -- p_conversion_rate IN CS_CONTRACTS.CONVERSION_RATE%TYPE := NULL,
701: -- p_conversion_date IN CS_CONTRACTS.CONVERSION_DATE%TYPE := NULL,
702: -- p_invoicing_rule_id IN CS_CONTRACTS.INVOICING_RULE_ID%TYPE := NULL,
703: -- p_accounting_rule_id IN CS_CONTRACTS.ACCOUNTING_RULE_ID%TYPE := NULL,
704: -- p_billing_frequency_period IN CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
705: -- p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := NULL,
706: -- p_next_bill_date IN CS_CONTRACTS.NEXT_BILL_DATE%TYPE := NULL,
707: -- p_create_sales_order IN CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := NULL,
708: -- p_renewal_rule IN CS_CONTRACTS.RENEWAL_RULE%TYPE := NULL,

Line 705: -- p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := NULL,

701: -- p_conversion_date IN CS_CONTRACTS.CONVERSION_DATE%TYPE := NULL,
702: -- p_invoicing_rule_id IN CS_CONTRACTS.INVOICING_RULE_ID%TYPE := NULL,
703: -- p_accounting_rule_id IN CS_CONTRACTS.ACCOUNTING_RULE_ID%TYPE := NULL,
704: -- p_billing_frequency_period IN CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
705: -- p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := NULL,
706: -- p_next_bill_date IN CS_CONTRACTS.NEXT_BILL_DATE%TYPE := NULL,
707: -- p_create_sales_order IN CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := NULL,
708: -- p_renewal_rule IN CS_CONTRACTS.RENEWAL_RULE%TYPE := NULL,
709: -- p_termination_rule IN CS_CONTRACTS.TERMINATION_RULE%TYPE := NULL,

Line 706: -- p_next_bill_date IN CS_CONTRACTS.NEXT_BILL_DATE%TYPE := NULL,

702: -- p_invoicing_rule_id IN CS_CONTRACTS.INVOICING_RULE_ID%TYPE := NULL,
703: -- p_accounting_rule_id IN CS_CONTRACTS.ACCOUNTING_RULE_ID%TYPE := NULL,
704: -- p_billing_frequency_period IN CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
705: -- p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := NULL,
706: -- p_next_bill_date IN CS_CONTRACTS.NEXT_BILL_DATE%TYPE := NULL,
707: -- p_create_sales_order IN CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := NULL,
708: -- p_renewal_rule IN CS_CONTRACTS.RENEWAL_RULE%TYPE := NULL,
709: -- p_termination_rule IN CS_CONTRACTS.TERMINATION_RULE%TYPE := NULL,
710: -- p_bill_to_site_use_id IN CS_CONTRACTS.BILL_TO_SITE_USE_ID%TYPE := NULL,

Line 707: -- p_create_sales_order IN CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := NULL,

703: -- p_accounting_rule_id IN CS_CONTRACTS.ACCOUNTING_RULE_ID%TYPE := NULL,
704: -- p_billing_frequency_period IN CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
705: -- p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := NULL,
706: -- p_next_bill_date IN CS_CONTRACTS.NEXT_BILL_DATE%TYPE := NULL,
707: -- p_create_sales_order IN CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := NULL,
708: -- p_renewal_rule IN CS_CONTRACTS.RENEWAL_RULE%TYPE := NULL,
709: -- p_termination_rule IN CS_CONTRACTS.TERMINATION_RULE%TYPE := NULL,
710: -- p_bill_to_site_use_id IN CS_CONTRACTS.BILL_TO_SITE_USE_ID%TYPE := NULL,
711: -- p_contract_status_id IN CS_CONTRACTS.CONTRACT_STATUS_ID%TYPE := NULL,

Line 708: -- p_renewal_rule IN CS_CONTRACTS.RENEWAL_RULE%TYPE := NULL,

704: -- p_billing_frequency_period IN CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
705: -- p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := NULL,
706: -- p_next_bill_date IN CS_CONTRACTS.NEXT_BILL_DATE%TYPE := NULL,
707: -- p_create_sales_order IN CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := NULL,
708: -- p_renewal_rule IN CS_CONTRACTS.RENEWAL_RULE%TYPE := NULL,
709: -- p_termination_rule IN CS_CONTRACTS.TERMINATION_RULE%TYPE := NULL,
710: -- p_bill_to_site_use_id IN CS_CONTRACTS.BILL_TO_SITE_USE_ID%TYPE := NULL,
711: -- p_contract_status_id IN CS_CONTRACTS.CONTRACT_STATUS_ID%TYPE := NULL,
712: -- p_contract_type_id IN CS_CONTRACTS.CONTRACT_TYPE_ID%TYPE := NULL,

Line 709: -- p_termination_rule IN CS_CONTRACTS.TERMINATION_RULE%TYPE := NULL,

705: -- p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := NULL,
706: -- p_next_bill_date IN CS_CONTRACTS.NEXT_BILL_DATE%TYPE := NULL,
707: -- p_create_sales_order IN CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := NULL,
708: -- p_renewal_rule IN CS_CONTRACTS.RENEWAL_RULE%TYPE := NULL,
709: -- p_termination_rule IN CS_CONTRACTS.TERMINATION_RULE%TYPE := NULL,
710: -- p_bill_to_site_use_id IN CS_CONTRACTS.BILL_TO_SITE_USE_ID%TYPE := NULL,
711: -- p_contract_status_id IN CS_CONTRACTS.CONTRACT_STATUS_ID%TYPE := NULL,
712: -- p_contract_type_id IN CS_CONTRACTS.CONTRACT_TYPE_ID%TYPE := NULL,
713: -- p_contract_template_id IN CS_CONTRACTS.CONTRACT_TEMPLATE_ID%TYPE := NULL,

Line 710: -- p_bill_to_site_use_id IN CS_CONTRACTS.BILL_TO_SITE_USE_ID%TYPE := NULL,

706: -- p_next_bill_date IN CS_CONTRACTS.NEXT_BILL_DATE%TYPE := NULL,
707: -- p_create_sales_order IN CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := NULL,
708: -- p_renewal_rule IN CS_CONTRACTS.RENEWAL_RULE%TYPE := NULL,
709: -- p_termination_rule IN CS_CONTRACTS.TERMINATION_RULE%TYPE := NULL,
710: -- p_bill_to_site_use_id IN CS_CONTRACTS.BILL_TO_SITE_USE_ID%TYPE := NULL,
711: -- p_contract_status_id IN CS_CONTRACTS.CONTRACT_STATUS_ID%TYPE := NULL,
712: -- p_contract_type_id IN CS_CONTRACTS.CONTRACT_TYPE_ID%TYPE := NULL,
713: -- p_contract_template_id IN CS_CONTRACTS.CONTRACT_TEMPLATE_ID%TYPE := NULL,
714: -- p_contract_group_id IN CS_CONTRACTS.CONTRACT_GROUP_ID%TYPE := NULL,

Line 711: -- p_contract_status_id IN CS_CONTRACTS.CONTRACT_STATUS_ID%TYPE := NULL,

707: -- p_create_sales_order IN CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := NULL,
708: -- p_renewal_rule IN CS_CONTRACTS.RENEWAL_RULE%TYPE := NULL,
709: -- p_termination_rule IN CS_CONTRACTS.TERMINATION_RULE%TYPE := NULL,
710: -- p_bill_to_site_use_id IN CS_CONTRACTS.BILL_TO_SITE_USE_ID%TYPE := NULL,
711: -- p_contract_status_id IN CS_CONTRACTS.CONTRACT_STATUS_ID%TYPE := NULL,
712: -- p_contract_type_id IN CS_CONTRACTS.CONTRACT_TYPE_ID%TYPE := NULL,
713: -- p_contract_template_id IN CS_CONTRACTS.CONTRACT_TEMPLATE_ID%TYPE := NULL,
714: -- p_contract_group_id IN CS_CONTRACTS.CONTRACT_GROUP_ID%TYPE := NULL,
715: -- p_customer_id IN CS_CONTRACTS.CUSTOMER_ID%TYPE := NULL,

Line 712: -- p_contract_type_id IN CS_CONTRACTS.CONTRACT_TYPE_ID%TYPE := NULL,

708: -- p_renewal_rule IN CS_CONTRACTS.RENEWAL_RULE%TYPE := NULL,
709: -- p_termination_rule IN CS_CONTRACTS.TERMINATION_RULE%TYPE := NULL,
710: -- p_bill_to_site_use_id IN CS_CONTRACTS.BILL_TO_SITE_USE_ID%TYPE := NULL,
711: -- p_contract_status_id IN CS_CONTRACTS.CONTRACT_STATUS_ID%TYPE := NULL,
712: -- p_contract_type_id IN CS_CONTRACTS.CONTRACT_TYPE_ID%TYPE := NULL,
713: -- p_contract_template_id IN CS_CONTRACTS.CONTRACT_TEMPLATE_ID%TYPE := NULL,
714: -- p_contract_group_id IN CS_CONTRACTS.CONTRACT_GROUP_ID%TYPE := NULL,
715: -- p_customer_id IN CS_CONTRACTS.CUSTOMER_ID%TYPE := NULL,
716: -- p_duration IN CS_CONTRACTS.DURATION%TYPE := NULL,

Line 713: -- p_contract_template_id IN CS_CONTRACTS.CONTRACT_TEMPLATE_ID%TYPE := NULL,

709: -- p_termination_rule IN CS_CONTRACTS.TERMINATION_RULE%TYPE := NULL,
710: -- p_bill_to_site_use_id IN CS_CONTRACTS.BILL_TO_SITE_USE_ID%TYPE := NULL,
711: -- p_contract_status_id IN CS_CONTRACTS.CONTRACT_STATUS_ID%TYPE := NULL,
712: -- p_contract_type_id IN CS_CONTRACTS.CONTRACT_TYPE_ID%TYPE := NULL,
713: -- p_contract_template_id IN CS_CONTRACTS.CONTRACT_TEMPLATE_ID%TYPE := NULL,
714: -- p_contract_group_id IN CS_CONTRACTS.CONTRACT_GROUP_ID%TYPE := NULL,
715: -- p_customer_id IN CS_CONTRACTS.CUSTOMER_ID%TYPE := NULL,
716: -- p_duration IN CS_CONTRACTS.DURATION%TYPE := NULL,
717: -- p_period_code IN CS_CONTRACTS.PERIOD_CODE%TYPE := NULL,

Line 714: -- p_contract_group_id IN CS_CONTRACTS.CONTRACT_GROUP_ID%TYPE := NULL,

710: -- p_bill_to_site_use_id IN CS_CONTRACTS.BILL_TO_SITE_USE_ID%TYPE := NULL,
711: -- p_contract_status_id IN CS_CONTRACTS.CONTRACT_STATUS_ID%TYPE := NULL,
712: -- p_contract_type_id IN CS_CONTRACTS.CONTRACT_TYPE_ID%TYPE := NULL,
713: -- p_contract_template_id IN CS_CONTRACTS.CONTRACT_TEMPLATE_ID%TYPE := NULL,
714: -- p_contract_group_id IN CS_CONTRACTS.CONTRACT_GROUP_ID%TYPE := NULL,
715: -- p_customer_id IN CS_CONTRACTS.CUSTOMER_ID%TYPE := NULL,
716: -- p_duration IN CS_CONTRACTS.DURATION%TYPE := NULL,
717: -- p_period_code IN CS_CONTRACTS.PERIOD_CODE%TYPE := NULL,
718: -- p_ship_to_site_use_id IN CS_CONTRACTS.SHIP_TO_SITE_USE_ID%TYPE := NULL,

Line 715: -- p_customer_id IN CS_CONTRACTS.CUSTOMER_ID%TYPE := NULL,

711: -- p_contract_status_id IN CS_CONTRACTS.CONTRACT_STATUS_ID%TYPE := NULL,
712: -- p_contract_type_id IN CS_CONTRACTS.CONTRACT_TYPE_ID%TYPE := NULL,
713: -- p_contract_template_id IN CS_CONTRACTS.CONTRACT_TEMPLATE_ID%TYPE := NULL,
714: -- p_contract_group_id IN CS_CONTRACTS.CONTRACT_GROUP_ID%TYPE := NULL,
715: -- p_customer_id IN CS_CONTRACTS.CUSTOMER_ID%TYPE := NULL,
716: -- p_duration IN CS_CONTRACTS.DURATION%TYPE := NULL,
717: -- p_period_code IN CS_CONTRACTS.PERIOD_CODE%TYPE := NULL,
718: -- p_ship_to_site_use_id IN CS_CONTRACTS.SHIP_TO_SITE_USE_ID%TYPE := NULL,
719: -- p_salesperson_id IN CS_CONTRACTS.SALESPERSON_ID%TYPE := NULL,

Line 716: -- p_duration IN CS_CONTRACTS.DURATION%TYPE := NULL,

712: -- p_contract_type_id IN CS_CONTRACTS.CONTRACT_TYPE_ID%TYPE := NULL,
713: -- p_contract_template_id IN CS_CONTRACTS.CONTRACT_TEMPLATE_ID%TYPE := NULL,
714: -- p_contract_group_id IN CS_CONTRACTS.CONTRACT_GROUP_ID%TYPE := NULL,
715: -- p_customer_id IN CS_CONTRACTS.CUSTOMER_ID%TYPE := NULL,
716: -- p_duration IN CS_CONTRACTS.DURATION%TYPE := NULL,
717: -- p_period_code IN CS_CONTRACTS.PERIOD_CODE%TYPE := NULL,
718: -- p_ship_to_site_use_id IN CS_CONTRACTS.SHIP_TO_SITE_USE_ID%TYPE := NULL,
719: -- p_salesperson_id IN CS_CONTRACTS.SALESPERSON_ID%TYPE := NULL,
720: -- p_ordered_by_contact_id IN CS_CONTRACTS.ORDERED_BY_CONTACT_ID%TYPE := NULL,

Line 717: -- p_period_code IN CS_CONTRACTS.PERIOD_CODE%TYPE := NULL,

713: -- p_contract_template_id IN CS_CONTRACTS.CONTRACT_TEMPLATE_ID%TYPE := NULL,
714: -- p_contract_group_id IN CS_CONTRACTS.CONTRACT_GROUP_ID%TYPE := NULL,
715: -- p_customer_id IN CS_CONTRACTS.CUSTOMER_ID%TYPE := NULL,
716: -- p_duration IN CS_CONTRACTS.DURATION%TYPE := NULL,
717: -- p_period_code IN CS_CONTRACTS.PERIOD_CODE%TYPE := NULL,
718: -- p_ship_to_site_use_id IN CS_CONTRACTS.SHIP_TO_SITE_USE_ID%TYPE := NULL,
719: -- p_salesperson_id IN CS_CONTRACTS.SALESPERSON_ID%TYPE := NULL,
720: -- p_ordered_by_contact_id IN CS_CONTRACTS.ORDERED_BY_CONTACT_ID%TYPE := NULL,
721: -- p_source_code IN CS_CONTRACTS.SOURCE_CODE%TYPE := NULL,

Line 718: -- p_ship_to_site_use_id IN CS_CONTRACTS.SHIP_TO_SITE_USE_ID%TYPE := NULL,

714: -- p_contract_group_id IN CS_CONTRACTS.CONTRACT_GROUP_ID%TYPE := NULL,
715: -- p_customer_id IN CS_CONTRACTS.CUSTOMER_ID%TYPE := NULL,
716: -- p_duration IN CS_CONTRACTS.DURATION%TYPE := NULL,
717: -- p_period_code IN CS_CONTRACTS.PERIOD_CODE%TYPE := NULL,
718: -- p_ship_to_site_use_id IN CS_CONTRACTS.SHIP_TO_SITE_USE_ID%TYPE := NULL,
719: -- p_salesperson_id IN CS_CONTRACTS.SALESPERSON_ID%TYPE := NULL,
720: -- p_ordered_by_contact_id IN CS_CONTRACTS.ORDERED_BY_CONTACT_ID%TYPE := NULL,
721: -- p_source_code IN CS_CONTRACTS.SOURCE_CODE%TYPE := NULL,
722: -- p_source_reference IN CS_CONTRACTS.SOURCE_REFERENCE%TYPE := NULL,

Line 719: -- p_salesperson_id IN CS_CONTRACTS.SALESPERSON_ID%TYPE := NULL,

715: -- p_customer_id IN CS_CONTRACTS.CUSTOMER_ID%TYPE := NULL,
716: -- p_duration IN CS_CONTRACTS.DURATION%TYPE := NULL,
717: -- p_period_code IN CS_CONTRACTS.PERIOD_CODE%TYPE := NULL,
718: -- p_ship_to_site_use_id IN CS_CONTRACTS.SHIP_TO_SITE_USE_ID%TYPE := NULL,
719: -- p_salesperson_id IN CS_CONTRACTS.SALESPERSON_ID%TYPE := NULL,
720: -- p_ordered_by_contact_id IN CS_CONTRACTS.ORDERED_BY_CONTACT_ID%TYPE := NULL,
721: -- p_source_code IN CS_CONTRACTS.SOURCE_CODE%TYPE := NULL,
722: -- p_source_reference IN CS_CONTRACTS.SOURCE_REFERENCE%TYPE := NULL,
723: -- p_terms_id IN CS_CONTRACTS.TERMS_ID%TYPE := NULL,

Line 720: -- p_ordered_by_contact_id IN CS_CONTRACTS.ORDERED_BY_CONTACT_ID%TYPE := NULL,

716: -- p_duration IN CS_CONTRACTS.DURATION%TYPE := NULL,
717: -- p_period_code IN CS_CONTRACTS.PERIOD_CODE%TYPE := NULL,
718: -- p_ship_to_site_use_id IN CS_CONTRACTS.SHIP_TO_SITE_USE_ID%TYPE := NULL,
719: -- p_salesperson_id IN CS_CONTRACTS.SALESPERSON_ID%TYPE := NULL,
720: -- p_ordered_by_contact_id IN CS_CONTRACTS.ORDERED_BY_CONTACT_ID%TYPE := NULL,
721: -- p_source_code IN CS_CONTRACTS.SOURCE_CODE%TYPE := NULL,
722: -- p_source_reference IN CS_CONTRACTS.SOURCE_REFERENCE%TYPE := NULL,
723: -- p_terms_id IN CS_CONTRACTS.TERMS_ID%TYPE := NULL,
724: -- p_po_number IN CS_CONTRACTS.PO_NUMBER%TYPE := NULL,

Line 721: -- p_source_code IN CS_CONTRACTS.SOURCE_CODE%TYPE := NULL,

717: -- p_period_code IN CS_CONTRACTS.PERIOD_CODE%TYPE := NULL,
718: -- p_ship_to_site_use_id IN CS_CONTRACTS.SHIP_TO_SITE_USE_ID%TYPE := NULL,
719: -- p_salesperson_id IN CS_CONTRACTS.SALESPERSON_ID%TYPE := NULL,
720: -- p_ordered_by_contact_id IN CS_CONTRACTS.ORDERED_BY_CONTACT_ID%TYPE := NULL,
721: -- p_source_code IN CS_CONTRACTS.SOURCE_CODE%TYPE := NULL,
722: -- p_source_reference IN CS_CONTRACTS.SOURCE_REFERENCE%TYPE := NULL,
723: -- p_terms_id IN CS_CONTRACTS.TERMS_ID%TYPE := NULL,
724: -- p_po_number IN CS_CONTRACTS.PO_NUMBER%TYPE := NULL,
725: -- p_bill_on IN CS_CONTRACTS.BILL_ON%TYPE := NULL,

Line 722: -- p_source_reference IN CS_CONTRACTS.SOURCE_REFERENCE%TYPE := NULL,

718: -- p_ship_to_site_use_id IN CS_CONTRACTS.SHIP_TO_SITE_USE_ID%TYPE := NULL,
719: -- p_salesperson_id IN CS_CONTRACTS.SALESPERSON_ID%TYPE := NULL,
720: -- p_ordered_by_contact_id IN CS_CONTRACTS.ORDERED_BY_CONTACT_ID%TYPE := NULL,
721: -- p_source_code IN CS_CONTRACTS.SOURCE_CODE%TYPE := NULL,
722: -- p_source_reference IN CS_CONTRACTS.SOURCE_REFERENCE%TYPE := NULL,
723: -- p_terms_id IN CS_CONTRACTS.TERMS_ID%TYPE := NULL,
724: -- p_po_number IN CS_CONTRACTS.PO_NUMBER%TYPE := NULL,
725: -- p_bill_on IN CS_CONTRACTS.BILL_ON%TYPE := NULL,
726: -- p_tax_handling IN CS_CONTRACTS.TAX_HANDLING%TYPE := NULL,

Line 723: -- p_terms_id IN CS_CONTRACTS.TERMS_ID%TYPE := NULL,

719: -- p_salesperson_id IN CS_CONTRACTS.SALESPERSON_ID%TYPE := NULL,
720: -- p_ordered_by_contact_id IN CS_CONTRACTS.ORDERED_BY_CONTACT_ID%TYPE := NULL,
721: -- p_source_code IN CS_CONTRACTS.SOURCE_CODE%TYPE := NULL,
722: -- p_source_reference IN CS_CONTRACTS.SOURCE_REFERENCE%TYPE := NULL,
723: -- p_terms_id IN CS_CONTRACTS.TERMS_ID%TYPE := NULL,
724: -- p_po_number IN CS_CONTRACTS.PO_NUMBER%TYPE := NULL,
725: -- p_bill_on IN CS_CONTRACTS.BILL_ON%TYPE := NULL,
726: -- p_tax_handling IN CS_CONTRACTS.TAX_HANDLING%TYPE := NULL,
727: -- p_tax_exempt_num IN CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := NULL,

Line 724: -- p_po_number IN CS_CONTRACTS.PO_NUMBER%TYPE := NULL,

720: -- p_ordered_by_contact_id IN CS_CONTRACTS.ORDERED_BY_CONTACT_ID%TYPE := NULL,
721: -- p_source_code IN CS_CONTRACTS.SOURCE_CODE%TYPE := NULL,
722: -- p_source_reference IN CS_CONTRACTS.SOURCE_REFERENCE%TYPE := NULL,
723: -- p_terms_id IN CS_CONTRACTS.TERMS_ID%TYPE := NULL,
724: -- p_po_number IN CS_CONTRACTS.PO_NUMBER%TYPE := NULL,
725: -- p_bill_on IN CS_CONTRACTS.BILL_ON%TYPE := NULL,
726: -- p_tax_handling IN CS_CONTRACTS.TAX_HANDLING%TYPE := NULL,
727: -- p_tax_exempt_num IN CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := NULL,
728: -- p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := NULL,

Line 725: -- p_bill_on IN CS_CONTRACTS.BILL_ON%TYPE := NULL,

721: -- p_source_code IN CS_CONTRACTS.SOURCE_CODE%TYPE := NULL,
722: -- p_source_reference IN CS_CONTRACTS.SOURCE_REFERENCE%TYPE := NULL,
723: -- p_terms_id IN CS_CONTRACTS.TERMS_ID%TYPE := NULL,
724: -- p_po_number IN CS_CONTRACTS.PO_NUMBER%TYPE := NULL,
725: -- p_bill_on IN CS_CONTRACTS.BILL_ON%TYPE := NULL,
726: -- p_tax_handling IN CS_CONTRACTS.TAX_HANDLING%TYPE := NULL,
727: -- p_tax_exempt_num IN CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := NULL,
728: -- p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
729: -- p_contract_amount IN CS_CONTRACTS.CONTRACT_AMOUNT%TYPE := NULL,

Line 726: -- p_tax_handling IN CS_CONTRACTS.TAX_HANDLING%TYPE := NULL,

722: -- p_source_reference IN CS_CONTRACTS.SOURCE_REFERENCE%TYPE := NULL,
723: -- p_terms_id IN CS_CONTRACTS.TERMS_ID%TYPE := NULL,
724: -- p_po_number IN CS_CONTRACTS.PO_NUMBER%TYPE := NULL,
725: -- p_bill_on IN CS_CONTRACTS.BILL_ON%TYPE := NULL,
726: -- p_tax_handling IN CS_CONTRACTS.TAX_HANDLING%TYPE := NULL,
727: -- p_tax_exempt_num IN CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := NULL,
728: -- p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
729: -- p_contract_amount IN CS_CONTRACTS.CONTRACT_AMOUNT%TYPE := NULL,
730: -- p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := NULL,

Line 727: -- p_tax_exempt_num IN CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := NULL,

723: -- p_terms_id IN CS_CONTRACTS.TERMS_ID%TYPE := NULL,
724: -- p_po_number IN CS_CONTRACTS.PO_NUMBER%TYPE := NULL,
725: -- p_bill_on IN CS_CONTRACTS.BILL_ON%TYPE := NULL,
726: -- p_tax_handling IN CS_CONTRACTS.TAX_HANDLING%TYPE := NULL,
727: -- p_tax_exempt_num IN CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := NULL,
728: -- p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
729: -- p_contract_amount IN CS_CONTRACTS.CONTRACT_AMOUNT%TYPE := NULL,
730: -- p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := NULL,
731: -- p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := NULL,

Line 728: -- p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := NULL,

724: -- p_po_number IN CS_CONTRACTS.PO_NUMBER%TYPE := NULL,
725: -- p_bill_on IN CS_CONTRACTS.BILL_ON%TYPE := NULL,
726: -- p_tax_handling IN CS_CONTRACTS.TAX_HANDLING%TYPE := NULL,
727: -- p_tax_exempt_num IN CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := NULL,
728: -- p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
729: -- p_contract_amount IN CS_CONTRACTS.CONTRACT_AMOUNT%TYPE := NULL,
730: -- p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := NULL,
731: -- p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := NULL,
732: -- p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := NULL,

Line 729: -- p_contract_amount IN CS_CONTRACTS.CONTRACT_AMOUNT%TYPE := NULL,

725: -- p_bill_on IN CS_CONTRACTS.BILL_ON%TYPE := NULL,
726: -- p_tax_handling IN CS_CONTRACTS.TAX_HANDLING%TYPE := NULL,
727: -- p_tax_exempt_num IN CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := NULL,
728: -- p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
729: -- p_contract_amount IN CS_CONTRACTS.CONTRACT_AMOUNT%TYPE := NULL,
730: -- p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := NULL,
731: -- p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := NULL,
732: -- p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := NULL,
733: -- p_discount_id IN CS_CONTRACTS.DISCOUNT_ID%TYPE := NULL,

Line 730: -- p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := NULL,

726: -- p_tax_handling IN CS_CONTRACTS.TAX_HANDLING%TYPE := NULL,
727: -- p_tax_exempt_num IN CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := NULL,
728: -- p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
729: -- p_contract_amount IN CS_CONTRACTS.CONTRACT_AMOUNT%TYPE := NULL,
730: -- p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := NULL,
731: -- p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := NULL,
732: -- p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := NULL,
733: -- p_discount_id IN CS_CONTRACTS.DISCOUNT_ID%TYPE := NULL,
734: -- p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := NULL,

Line 731: -- p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := NULL,

727: -- p_tax_exempt_num IN CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := NULL,
728: -- p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
729: -- p_contract_amount IN CS_CONTRACTS.CONTRACT_AMOUNT%TYPE := NULL,
730: -- p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := NULL,
731: -- p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := NULL,
732: -- p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := NULL,
733: -- p_discount_id IN CS_CONTRACTS.DISCOUNT_ID%TYPE := NULL,
734: -- p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := NULL,
735: -- p_pre_payment_required IN CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := NULL,

Line 732: -- p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := NULL,

728: -- p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
729: -- p_contract_amount IN CS_CONTRACTS.CONTRACT_AMOUNT%TYPE := NULL,
730: -- p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := NULL,
731: -- p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := NULL,
732: -- p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := NULL,
733: -- p_discount_id IN CS_CONTRACTS.DISCOUNT_ID%TYPE := NULL,
734: -- p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := NULL,
735: -- p_pre_payment_required IN CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := NULL,
736: -- p_last_update_date IN CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := NULL,

Line 733: -- p_discount_id IN CS_CONTRACTS.DISCOUNT_ID%TYPE := NULL,

729: -- p_contract_amount IN CS_CONTRACTS.CONTRACT_AMOUNT%TYPE := NULL,
730: -- p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := NULL,
731: -- p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := NULL,
732: -- p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := NULL,
733: -- p_discount_id IN CS_CONTRACTS.DISCOUNT_ID%TYPE := NULL,
734: -- p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := NULL,
735: -- p_pre_payment_required IN CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := NULL,
736: -- p_last_update_date IN CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := NULL,
737: -- p_last_updated_by IN CS_CONTRACTS.LAST_UPDATED_BY%TYPE := NULL,

Line 734: -- p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := NULL,

730: -- p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := NULL,
731: -- p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := NULL,
732: -- p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := NULL,
733: -- p_discount_id IN CS_CONTRACTS.DISCOUNT_ID%TYPE := NULL,
734: -- p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := NULL,
735: -- p_pre_payment_required IN CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := NULL,
736: -- p_last_update_date IN CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := NULL,
737: -- p_last_updated_by IN CS_CONTRACTS.LAST_UPDATED_BY%TYPE := NULL,
738: -- p_creation_date IN CS_CONTRACTS.CREATION_DATE%TYPE := NULL,

Line 735: -- p_pre_payment_required IN CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := NULL,

731: -- p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := NULL,
732: -- p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := NULL,
733: -- p_discount_id IN CS_CONTRACTS.DISCOUNT_ID%TYPE := NULL,
734: -- p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := NULL,
735: -- p_pre_payment_required IN CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := NULL,
736: -- p_last_update_date IN CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := NULL,
737: -- p_last_updated_by IN CS_CONTRACTS.LAST_UPDATED_BY%TYPE := NULL,
738: -- p_creation_date IN CS_CONTRACTS.CREATION_DATE%TYPE := NULL,
739: -- p_created_by IN CS_CONTRACTS.CREATED_BY%TYPE := NULL,

Line 736: -- p_last_update_date IN CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := NULL,

732: -- p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := NULL,
733: -- p_discount_id IN CS_CONTRACTS.DISCOUNT_ID%TYPE := NULL,
734: -- p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := NULL,
735: -- p_pre_payment_required IN CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := NULL,
736: -- p_last_update_date IN CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := NULL,
737: -- p_last_updated_by IN CS_CONTRACTS.LAST_UPDATED_BY%TYPE := NULL,
738: -- p_creation_date IN CS_CONTRACTS.CREATION_DATE%TYPE := NULL,
739: -- p_created_by IN CS_CONTRACTS.CREATED_BY%TYPE := NULL,
740: -- p_last_update_login IN CS_CONTRACTS.LAST_UPDATE_LOGIN%TYPE := NULL,

Line 737: -- p_last_updated_by IN CS_CONTRACTS.LAST_UPDATED_BY%TYPE := NULL,

733: -- p_discount_id IN CS_CONTRACTS.DISCOUNT_ID%TYPE := NULL,
734: -- p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := NULL,
735: -- p_pre_payment_required IN CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := NULL,
736: -- p_last_update_date IN CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := NULL,
737: -- p_last_updated_by IN CS_CONTRACTS.LAST_UPDATED_BY%TYPE := NULL,
738: -- p_creation_date IN CS_CONTRACTS.CREATION_DATE%TYPE := NULL,
739: -- p_created_by IN CS_CONTRACTS.CREATED_BY%TYPE := NULL,
740: -- p_last_update_login IN CS_CONTRACTS.LAST_UPDATE_LOGIN%TYPE := NULL,
741: -- p_start_date_active IN CS_CONTRACTS.START_DATE_ACTIVE%TYPE := NULL,

Line 738: -- p_creation_date IN CS_CONTRACTS.CREATION_DATE%TYPE := NULL,

734: -- p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := NULL,
735: -- p_pre_payment_required IN CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := NULL,
736: -- p_last_update_date IN CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := NULL,
737: -- p_last_updated_by IN CS_CONTRACTS.LAST_UPDATED_BY%TYPE := NULL,
738: -- p_creation_date IN CS_CONTRACTS.CREATION_DATE%TYPE := NULL,
739: -- p_created_by IN CS_CONTRACTS.CREATED_BY%TYPE := NULL,
740: -- p_last_update_login IN CS_CONTRACTS.LAST_UPDATE_LOGIN%TYPE := NULL,
741: -- p_start_date_active IN CS_CONTRACTS.START_DATE_ACTIVE%TYPE := NULL,
742: -- p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := NULL,

Line 739: -- p_created_by IN CS_CONTRACTS.CREATED_BY%TYPE := NULL,

735: -- p_pre_payment_required IN CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := NULL,
736: -- p_last_update_date IN CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := NULL,
737: -- p_last_updated_by IN CS_CONTRACTS.LAST_UPDATED_BY%TYPE := NULL,
738: -- p_creation_date IN CS_CONTRACTS.CREATION_DATE%TYPE := NULL,
739: -- p_created_by IN CS_CONTRACTS.CREATED_BY%TYPE := NULL,
740: -- p_last_update_login IN CS_CONTRACTS.LAST_UPDATE_LOGIN%TYPE := NULL,
741: -- p_start_date_active IN CS_CONTRACTS.START_DATE_ACTIVE%TYPE := NULL,
742: -- p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := NULL,
743: -- p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := NULL,

Line 740: -- p_last_update_login IN CS_CONTRACTS.LAST_UPDATE_LOGIN%TYPE := NULL,

736: -- p_last_update_date IN CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := NULL,
737: -- p_last_updated_by IN CS_CONTRACTS.LAST_UPDATED_BY%TYPE := NULL,
738: -- p_creation_date IN CS_CONTRACTS.CREATION_DATE%TYPE := NULL,
739: -- p_created_by IN CS_CONTRACTS.CREATED_BY%TYPE := NULL,
740: -- p_last_update_login IN CS_CONTRACTS.LAST_UPDATE_LOGIN%TYPE := NULL,
741: -- p_start_date_active IN CS_CONTRACTS.START_DATE_ACTIVE%TYPE := NULL,
742: -- p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := NULL,
743: -- p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := NULL,
744: -- p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := NULL,

Line 741: -- p_start_date_active IN CS_CONTRACTS.START_DATE_ACTIVE%TYPE := NULL,

737: -- p_last_updated_by IN CS_CONTRACTS.LAST_UPDATED_BY%TYPE := NULL,
738: -- p_creation_date IN CS_CONTRACTS.CREATION_DATE%TYPE := NULL,
739: -- p_created_by IN CS_CONTRACTS.CREATED_BY%TYPE := NULL,
740: -- p_last_update_login IN CS_CONTRACTS.LAST_UPDATE_LOGIN%TYPE := NULL,
741: -- p_start_date_active IN CS_CONTRACTS.START_DATE_ACTIVE%TYPE := NULL,
742: -- p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := NULL,
743: -- p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := NULL,
744: -- p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := NULL,
745: -- p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := NULL,

Line 742: -- p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := NULL,

738: -- p_creation_date IN CS_CONTRACTS.CREATION_DATE%TYPE := NULL,
739: -- p_created_by IN CS_CONTRACTS.CREATED_BY%TYPE := NULL,
740: -- p_last_update_login IN CS_CONTRACTS.LAST_UPDATE_LOGIN%TYPE := NULL,
741: -- p_start_date_active IN CS_CONTRACTS.START_DATE_ACTIVE%TYPE := NULL,
742: -- p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := NULL,
743: -- p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := NULL,
744: -- p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := NULL,
745: -- p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := NULL,
746: -- p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := NULL,

Line 743: -- p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := NULL,

739: -- p_created_by IN CS_CONTRACTS.CREATED_BY%TYPE := NULL,
740: -- p_last_update_login IN CS_CONTRACTS.LAST_UPDATE_LOGIN%TYPE := NULL,
741: -- p_start_date_active IN CS_CONTRACTS.START_DATE_ACTIVE%TYPE := NULL,
742: -- p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := NULL,
743: -- p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := NULL,
744: -- p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := NULL,
745: -- p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := NULL,
746: -- p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := NULL,
747: -- p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := NULL,

Line 744: -- p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := NULL,

740: -- p_last_update_login IN CS_CONTRACTS.LAST_UPDATE_LOGIN%TYPE := NULL,
741: -- p_start_date_active IN CS_CONTRACTS.START_DATE_ACTIVE%TYPE := NULL,
742: -- p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := NULL,
743: -- p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := NULL,
744: -- p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := NULL,
745: -- p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := NULL,
746: -- p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := NULL,
747: -- p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := NULL,
748: -- p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := NULL,

Line 745: -- p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := NULL,

741: -- p_start_date_active IN CS_CONTRACTS.START_DATE_ACTIVE%TYPE := NULL,
742: -- p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := NULL,
743: -- p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := NULL,
744: -- p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := NULL,
745: -- p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := NULL,
746: -- p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := NULL,
747: -- p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := NULL,
748: -- p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := NULL,
749: -- p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := NULL,

Line 746: -- p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := NULL,

742: -- p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := NULL,
743: -- p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := NULL,
744: -- p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := NULL,
745: -- p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := NULL,
746: -- p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := NULL,
747: -- p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := NULL,
748: -- p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := NULL,
749: -- p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := NULL,
750: -- p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := NULL,

Line 747: -- p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := NULL,

743: -- p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := NULL,
744: -- p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := NULL,
745: -- p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := NULL,
746: -- p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := NULL,
747: -- p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := NULL,
748: -- p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := NULL,
749: -- p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := NULL,
750: -- p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := NULL,
751: -- p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := NULL,

Line 748: -- p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := NULL,

744: -- p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := NULL,
745: -- p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := NULL,
746: -- p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := NULL,
747: -- p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := NULL,
748: -- p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := NULL,
749: -- p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := NULL,
750: -- p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := NULL,
751: -- p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := NULL,
752: -- p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := NULL,

Line 749: -- p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := NULL,

745: -- p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := NULL,
746: -- p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := NULL,
747: -- p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := NULL,
748: -- p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := NULL,
749: -- p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := NULL,
750: -- p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := NULL,
751: -- p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := NULL,
752: -- p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := NULL,
753: -- p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := NULL,

Line 750: -- p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := NULL,

746: -- p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := NULL,
747: -- p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := NULL,
748: -- p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := NULL,
749: -- p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := NULL,
750: -- p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := NULL,
751: -- p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := NULL,
752: -- p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := NULL,
753: -- p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := NULL,
754: -- p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := NULL,

Line 751: -- p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := NULL,

747: -- p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := NULL,
748: -- p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := NULL,
749: -- p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := NULL,
750: -- p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := NULL,
751: -- p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := NULL,
752: -- p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := NULL,
753: -- p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := NULL,
754: -- p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := NULL,
755: -- p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := NULL,

Line 752: -- p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := NULL,

748: -- p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := NULL,
749: -- p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := NULL,
750: -- p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := NULL,
751: -- p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := NULL,
752: -- p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := NULL,
753: -- p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := NULL,
754: -- p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := NULL,
755: -- p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := NULL,
756: -- p_attribute14 IN CS_CONTRACTS.ATTRIBUTE14%TYPE := NULL,

Line 753: -- p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := NULL,

749: -- p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := NULL,
750: -- p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := NULL,
751: -- p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := NULL,
752: -- p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := NULL,
753: -- p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := NULL,
754: -- p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := NULL,
755: -- p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := NULL,
756: -- p_attribute14 IN CS_CONTRACTS.ATTRIBUTE14%TYPE := NULL,
757: -- p_attribute15 IN CS_CONTRACTS.ATTRIBUTE15%TYPE := NULL,

Line 754: -- p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := NULL,

750: -- p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := NULL,
751: -- p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := NULL,
752: -- p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := NULL,
753: -- p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := NULL,
754: -- p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := NULL,
755: -- p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := NULL,
756: -- p_attribute14 IN CS_CONTRACTS.ATTRIBUTE14%TYPE := NULL,
757: -- p_attribute15 IN CS_CONTRACTS.ATTRIBUTE15%TYPE := NULL,
758: -- p_context IN CS_CONTRACTS.CONTEXT%TYPE := NULL,

Line 755: -- p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := NULL,

751: -- p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := NULL,
752: -- p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := NULL,
753: -- p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := NULL,
754: -- p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := NULL,
755: -- p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := NULL,
756: -- p_attribute14 IN CS_CONTRACTS.ATTRIBUTE14%TYPE := NULL,
757: -- p_attribute15 IN CS_CONTRACTS.ATTRIBUTE15%TYPE := NULL,
758: -- p_context IN CS_CONTRACTS.CONTEXT%TYPE := NULL,
759: -- p_object_version_number IN CS_CONTRACTS.OBJECT_VERSION_NUMBER%TYPE := NULL

Line 756: -- p_attribute14 IN CS_CONTRACTS.ATTRIBUTE14%TYPE := NULL,

752: -- p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := NULL,
753: -- p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := NULL,
754: -- p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := NULL,
755: -- p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := NULL,
756: -- p_attribute14 IN CS_CONTRACTS.ATTRIBUTE14%TYPE := NULL,
757: -- p_attribute15 IN CS_CONTRACTS.ATTRIBUTE15%TYPE := NULL,
758: -- p_context IN CS_CONTRACTS.CONTEXT%TYPE := NULL,
759: -- p_object_version_number IN CS_CONTRACTS.OBJECT_VERSION_NUMBER%TYPE := NULL
760: ) IS

Line 757: -- p_attribute15 IN CS_CONTRACTS.ATTRIBUTE15%TYPE := NULL,

753: -- p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := NULL,
754: -- p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := NULL,
755: -- p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := NULL,
756: -- p_attribute14 IN CS_CONTRACTS.ATTRIBUTE14%TYPE := NULL,
757: -- p_attribute15 IN CS_CONTRACTS.ATTRIBUTE15%TYPE := NULL,
758: -- p_context IN CS_CONTRACTS.CONTEXT%TYPE := NULL,
759: -- p_object_version_number IN CS_CONTRACTS.OBJECT_VERSION_NUMBER%TYPE := NULL
760: ) IS
761: l_api_name CONSTANT VARCHAR2(30) := 'validate_contract';

Line 758: -- p_context IN CS_CONTRACTS.CONTEXT%TYPE := NULL,

754: -- p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := NULL,
755: -- p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := NULL,
756: -- p_attribute14 IN CS_CONTRACTS.ATTRIBUTE14%TYPE := NULL,
757: -- p_attribute15 IN CS_CONTRACTS.ATTRIBUTE15%TYPE := NULL,
758: -- p_context IN CS_CONTRACTS.CONTEXT%TYPE := NULL,
759: -- p_object_version_number IN CS_CONTRACTS.OBJECT_VERSION_NUMBER%TYPE := NULL
760: ) IS
761: l_api_name CONSTANT VARCHAR2(30) := 'validate_contract';
762: l_api_version CONSTANT NUMBER := 1;

Line 759: -- p_object_version_number IN CS_CONTRACTS.OBJECT_VERSION_NUMBER%TYPE := NULL

755: -- p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := NULL,
756: -- p_attribute14 IN CS_CONTRACTS.ATTRIBUTE14%TYPE := NULL,
757: -- p_attribute15 IN CS_CONTRACTS.ATTRIBUTE15%TYPE := NULL,
758: -- p_context IN CS_CONTRACTS.CONTEXT%TYPE := NULL,
759: -- p_object_version_number IN CS_CONTRACTS.OBJECT_VERSION_NUMBER%TYPE := NULL
760: ) IS
761: l_api_name CONSTANT VARCHAR2(30) := 'validate_contract';
762: l_api_version CONSTANT NUMBER := 1;
763: l_return_status VARCHAR2(1);

Line 908: p_workflow IN CS_CONTRACTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

904: x_msg_count OUT NUMBER,
905: x_msg_data OUT VARCHAR2,
906: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
907: p_contract_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
908: p_workflow IN CS_CONTRACTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_workflow_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
910: p_agreement_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
911: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
912: p_currency_code IN CS_CONTRACTS.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 912: p_currency_code IN CS_CONTRACTS.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

908: p_workflow IN CS_CONTRACTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_workflow_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
910: p_agreement_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
911: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
912: p_currency_code IN CS_CONTRACTS.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
913: p_conversion_type_code IN CS_CONTRACTS.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
914: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
915: p_conversion_date IN CS_CONTRACTS.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
916: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 913: p_conversion_type_code IN CS_CONTRACTS.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

909: p_workflow_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
910: p_agreement_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
911: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
912: p_currency_code IN CS_CONTRACTS.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
913: p_conversion_type_code IN CS_CONTRACTS.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
914: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
915: p_conversion_date IN CS_CONTRACTS.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
916: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
917: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 915: p_conversion_date IN CS_CONTRACTS.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

911: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
912: p_currency_code IN CS_CONTRACTS.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
913: p_conversion_type_code IN CS_CONTRACTS.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
914: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
915: p_conversion_date IN CS_CONTRACTS.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
916: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
917: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
918: p_billing_frequency_period IN CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
919: p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 918: p_billing_frequency_period IN CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

914: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
915: p_conversion_date IN CS_CONTRACTS.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
916: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
917: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
918: p_billing_frequency_period IN CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
919: p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
920: p_next_bill_date IN CS_CONTRACTS.NEXT_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
921: p_create_sales_order IN CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
922: p_renewal_rule IN CS_CONTRACTS.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 919: p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

915: p_conversion_date IN CS_CONTRACTS.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
916: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
917: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
918: p_billing_frequency_period IN CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
919: p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
920: p_next_bill_date IN CS_CONTRACTS.NEXT_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
921: p_create_sales_order IN CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
922: p_renewal_rule IN CS_CONTRACTS.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
923: p_termination_rule IN CS_CONTRACTS.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 920: p_next_bill_date IN CS_CONTRACTS.NEXT_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

916: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
917: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
918: p_billing_frequency_period IN CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
919: p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
920: p_next_bill_date IN CS_CONTRACTS.NEXT_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
921: p_create_sales_order IN CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
922: p_renewal_rule IN CS_CONTRACTS.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
923: p_termination_rule IN CS_CONTRACTS.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
924: p_bill_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 921: p_create_sales_order IN CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

917: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
918: p_billing_frequency_period IN CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
919: p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
920: p_next_bill_date IN CS_CONTRACTS.NEXT_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
921: p_create_sales_order IN CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
922: p_renewal_rule IN CS_CONTRACTS.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
923: p_termination_rule IN CS_CONTRACTS.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
924: p_bill_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
925: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 922: p_renewal_rule IN CS_CONTRACTS.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

918: p_billing_frequency_period IN CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
919: p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
920: p_next_bill_date IN CS_CONTRACTS.NEXT_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
921: p_create_sales_order IN CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
922: p_renewal_rule IN CS_CONTRACTS.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
923: p_termination_rule IN CS_CONTRACTS.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
924: p_bill_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
925: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
926: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 923: p_termination_rule IN CS_CONTRACTS.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

919: p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
920: p_next_bill_date IN CS_CONTRACTS.NEXT_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
921: p_create_sales_order IN CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
922: p_renewal_rule IN CS_CONTRACTS.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
923: p_termination_rule IN CS_CONTRACTS.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
924: p_bill_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
925: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
926: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
927: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 931: p_period_code IN CS_CONTRACTS.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

927: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
928: p_contract_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
929: p_customer_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
930: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
931: p_period_code IN CS_CONTRACTS.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
932: p_ship_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
933: p_salesperson_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
934: p_ordered_by_contact_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
935: p_source_code IN CS_CONTRACTS.SOURCE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 935: p_source_code IN CS_CONTRACTS.SOURCE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

931: p_period_code IN CS_CONTRACTS.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
932: p_ship_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
933: p_salesperson_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
934: p_ordered_by_contact_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
935: p_source_code IN CS_CONTRACTS.SOURCE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
936: p_source_reference IN CS_CONTRACTS.SOURCE_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
937: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
938: p_po_number IN CS_CONTRACTS.PO_NUMBER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_bill_on IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 936: p_source_reference IN CS_CONTRACTS.SOURCE_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

932: p_ship_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
933: p_salesperson_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
934: p_ordered_by_contact_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
935: p_source_code IN CS_CONTRACTS.SOURCE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
936: p_source_reference IN CS_CONTRACTS.SOURCE_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
937: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
938: p_po_number IN CS_CONTRACTS.PO_NUMBER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_bill_on IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
940: p_tax_handling IN CS_CONTRACTS.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 938: p_po_number IN CS_CONTRACTS.PO_NUMBER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

934: p_ordered_by_contact_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
935: p_source_code IN CS_CONTRACTS.SOURCE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
936: p_source_reference IN CS_CONTRACTS.SOURCE_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
937: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
938: p_po_number IN CS_CONTRACTS.PO_NUMBER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_bill_on IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
940: p_tax_handling IN CS_CONTRACTS.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
941: p_tax_exempt_num IN CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
942: p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 940: p_tax_handling IN CS_CONTRACTS.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

936: p_source_reference IN CS_CONTRACTS.SOURCE_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
937: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
938: p_po_number IN CS_CONTRACTS.PO_NUMBER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_bill_on IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
940: p_tax_handling IN CS_CONTRACTS.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
941: p_tax_exempt_num IN CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
942: p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
943: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
944: p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 941: p_tax_exempt_num IN CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

937: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
938: p_po_number IN CS_CONTRACTS.PO_NUMBER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_bill_on IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
940: p_tax_handling IN CS_CONTRACTS.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
941: p_tax_exempt_num IN CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
942: p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
943: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
944: p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
945: p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 942: p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

938: p_po_number IN CS_CONTRACTS.PO_NUMBER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_bill_on IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
940: p_tax_handling IN CS_CONTRACTS.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
941: p_tax_exempt_num IN CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
942: p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
943: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
944: p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
945: p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
946: p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 944: p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

940: p_tax_handling IN CS_CONTRACTS.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
941: p_tax_exempt_num IN CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
942: p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
943: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
944: p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
945: p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
946: p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
947: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
948: p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 945: p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

941: p_tax_exempt_num IN CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
942: p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
943: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
944: p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
945: p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
946: p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
947: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
948: p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
949: p_pre_payment_required IN CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 946: p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

942: p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
943: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
944: p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
945: p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
946: p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
947: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
948: p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
949: p_pre_payment_required IN CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
950: p_last_update_date IN CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 948: p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

944: p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
945: p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
946: p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
947: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
948: p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
949: p_pre_payment_required IN CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
950: p_last_update_date IN CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
951: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
952: p_creation_date IN CS_CONTRACTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 949: p_pre_payment_required IN CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

945: p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
946: p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
947: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
948: p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
949: p_pre_payment_required IN CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
950: p_last_update_date IN CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
951: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
952: p_creation_date IN CS_CONTRACTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
953: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 950: p_last_update_date IN CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

946: p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
947: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
948: p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
949: p_pre_payment_required IN CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
950: p_last_update_date IN CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
951: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
952: p_creation_date IN CS_CONTRACTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
953: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
954: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 952: p_creation_date IN CS_CONTRACTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

948: p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
949: p_pre_payment_required IN CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
950: p_last_update_date IN CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
951: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
952: p_creation_date IN CS_CONTRACTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
953: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
954: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
955: p_start_date_active IN CS_CONTRACTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
956: p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 955: p_start_date_active IN CS_CONTRACTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

951: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
952: p_creation_date IN CS_CONTRACTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
953: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
954: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
955: p_start_date_active IN CS_CONTRACTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
956: p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
957: p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
958: p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
959: p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 956: p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

952: p_creation_date IN CS_CONTRACTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
953: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
954: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
955: p_start_date_active IN CS_CONTRACTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
956: p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
957: p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
958: p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
959: p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
960: p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 957: p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

953: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
954: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
955: p_start_date_active IN CS_CONTRACTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
956: p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
957: p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
958: p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
959: p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
960: p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
961: p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 958: p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

954: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
955: p_start_date_active IN CS_CONTRACTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
956: p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
957: p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
958: p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
959: p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
960: p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
961: p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
962: p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 959: p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

955: p_start_date_active IN CS_CONTRACTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
956: p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
957: p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
958: p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
959: p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
960: p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
961: p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
962: p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
963: p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 960: p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

956: p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
957: p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
958: p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
959: p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
960: p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
961: p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
962: p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
963: p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
964: p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 961: p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

957: p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
958: p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
959: p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
960: p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
961: p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
962: p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
963: p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
964: p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
965: p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 962: p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

958: p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
959: p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
960: p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
961: p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
962: p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
963: p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
964: p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
965: p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
966: p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 963: p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

959: p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
960: p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
961: p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
962: p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
963: p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
964: p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
965: p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
966: p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
967: p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 964: p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

960: p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
961: p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
962: p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
963: p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
964: p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
965: p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
966: p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
967: p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
968: p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 965: p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

961: p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
962: p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
963: p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
964: p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
965: p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
966: p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
967: p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
968: p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
969: p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 966: p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

962: p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
963: p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
964: p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
965: p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
966: p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
967: p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
968: p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
969: p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
970: p_attribute14 IN CS_CONTRACTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 967: p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

963: p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
964: p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
965: p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
966: p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
967: p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
968: p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
969: p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
970: p_attribute14 IN CS_CONTRACTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
971: p_attribute15 IN CS_CONTRACTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 968: p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

964: p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
965: p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
966: p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
967: p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
968: p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
969: p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
970: p_attribute14 IN CS_CONTRACTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
971: p_attribute15 IN CS_CONTRACTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
972: p_context IN CS_CONTRACTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 969: p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

965: p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
966: p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
967: p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
968: p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
969: p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
970: p_attribute14 IN CS_CONTRACTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
971: p_attribute15 IN CS_CONTRACTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
972: p_context IN CS_CONTRACTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
973: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 970: p_attribute14 IN CS_CONTRACTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

966: p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
967: p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
968: p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
969: p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
970: p_attribute14 IN CS_CONTRACTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
971: p_attribute15 IN CS_CONTRACTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
972: p_context IN CS_CONTRACTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
973: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
974: x_object_version_number OUT NUMBER) IS

Line 971: p_attribute15 IN CS_CONTRACTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

967: p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
968: p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
969: p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
970: p_attribute14 IN CS_CONTRACTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
971: p_attribute15 IN CS_CONTRACTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
972: p_context IN CS_CONTRACTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
973: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
974: x_object_version_number OUT NUMBER) IS
975: l_api_name CONSTANT VARCHAR2(30) := 'update_contract';

Line 972: p_context IN CS_CONTRACTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

968: p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
969: p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
970: p_attribute14 IN CS_CONTRACTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
971: p_attribute15 IN CS_CONTRACTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
972: p_context IN CS_CONTRACTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
973: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
974: x_object_version_number OUT NUMBER) IS
975: l_api_name CONSTANT VARCHAR2(30) := 'update_contract';
976: l_api_version CONSTANT NUMBER := 1;

Line 979: p_old_status_id CS_CONTRACTS.CONTRACT_STATUS_ID%TYPE;

975: l_api_name CONSTANT VARCHAR2(30) := 'update_contract';
976: l_api_version CONSTANT NUMBER := 1;
977: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
978: l_contract_rec CS_CONTRACT_PVT.Contract_Val_Rec_Type;
979: p_old_status_id CS_CONTRACTS.CONTRACT_STATUS_ID%TYPE;
980: p_new_status_id CS_CONTRACTS.CONTRACT_STATUS_ID%TYPE;
981: p_inv_flag CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE;
982: BEGIN
983: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

Line 980: p_new_status_id CS_CONTRACTS.CONTRACT_STATUS_ID%TYPE;

976: l_api_version CONSTANT NUMBER := 1;
977: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
978: l_contract_rec CS_CONTRACT_PVT.Contract_Val_Rec_Type;
979: p_old_status_id CS_CONTRACTS.CONTRACT_STATUS_ID%TYPE;
980: p_new_status_id CS_CONTRACTS.CONTRACT_STATUS_ID%TYPE;
981: p_inv_flag CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE;
982: BEGIN
983: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
984: G_PKG_NAME,

Line 999: FROM CS_CONTRACTS

995: --- Get the old status id
996:
997: SELECT contract_status_id
998: INTO p_old_status_id
999: FROM CS_CONTRACTS
1000: WHERE contract_id = p_contract_id;
1001:
1002: l_contract_rec.CONTRACT_ID := p_contract_id;
1003: l_contract_rec.CONTRACT_NUMBER := p_contract_number;

Line 1086: FROM CS_CONTRACTS

1082: --- Get the new status id after the update
1083:
1084: SELECT contract_status_id
1085: INTO p_new_status_id
1086: FROM CS_CONTRACTS
1087: WHERE contract_id = l_contract_rec.contract_id;
1088:
1089: SELECT eligible_for_invoicing
1090: INTO p_inv_flag

Line 1162: END cs_contracts_pub;

1158: END Update_Contract;
1159:
1160: BEGIN
1161: null;
1162: END cs_contracts_pub;