4: -- Global Message Constants
5: G_INVALID_STS_APPROVED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_APPROVED'; -- token CHANGE_REQ_NUM
6:
7: -- Global lookup_code constants
8: G_PENDING_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PENDING_APPROVAL';
9: G_APPROVED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'APPROVED';
10: G_ARGREEMENT_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'AGREEMENT';
11: G_ASSOCIATE_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ASSOCIATION';
12: G_PROGRAM_SCS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PROGRAM';
5: G_INVALID_STS_APPROVED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_APPROVED'; -- token CHANGE_REQ_NUM
6:
7: -- Global lookup_code constants
8: G_PENDING_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PENDING_APPROVAL';
9: G_APPROVED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'APPROVED';
10: G_ARGREEMENT_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'AGREEMENT';
11: G_ASSOCIATE_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ASSOCIATION';
12: G_PROGRAM_SCS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PROGRAM';
13: G_OPERATING_SCS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'OPERATING';
6:
7: -- Global lookup_code constants
8: G_PENDING_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PENDING_APPROVAL';
9: G_APPROVED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'APPROVED';
10: G_ARGREEMENT_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'AGREEMENT';
11: G_ASSOCIATE_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ASSOCIATION';
12: G_PROGRAM_SCS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PROGRAM';
13: G_OPERATING_SCS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'OPERATING';
14: G_VENDOR_PROGRAM_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'VENDOR_PROGRAM';
7: -- Global lookup_code constants
8: G_PENDING_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PENDING_APPROVAL';
9: G_APPROVED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'APPROVED';
10: G_ARGREEMENT_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'AGREEMENT';
11: G_ASSOCIATE_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ASSOCIATION';
12: G_PROGRAM_SCS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PROGRAM';
13: G_OPERATING_SCS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'OPERATING';
14: G_VENDOR_PROGRAM_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'VENDOR_PROGRAM';
15: G_ABANDONED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ABANDONED';
8: G_PENDING_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PENDING_APPROVAL';
9: G_APPROVED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'APPROVED';
10: G_ARGREEMENT_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'AGREEMENT';
11: G_ASSOCIATE_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ASSOCIATION';
12: G_PROGRAM_SCS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PROGRAM';
13: G_OPERATING_SCS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'OPERATING';
14: G_VENDOR_PROGRAM_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'VENDOR_PROGRAM';
15: G_ABANDONED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ABANDONED';
16: G_COMPLETED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'COMPLETED';
9: G_APPROVED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'APPROVED';
10: G_ARGREEMENT_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'AGREEMENT';
11: G_ASSOCIATE_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ASSOCIATION';
12: G_PROGRAM_SCS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PROGRAM';
13: G_OPERATING_SCS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'OPERATING';
14: G_VENDOR_PROGRAM_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'VENDOR_PROGRAM';
15: G_ABANDONED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ABANDONED';
16: G_COMPLETED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'COMPLETED';
17:
10: G_ARGREEMENT_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'AGREEMENT';
11: G_ASSOCIATE_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ASSOCIATION';
12: G_PROGRAM_SCS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PROGRAM';
13: G_OPERATING_SCS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'OPERATING';
14: G_VENDOR_PROGRAM_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'VENDOR_PROGRAM';
15: G_ABANDONED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ABANDONED';
16: G_COMPLETED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'COMPLETED';
17:
18: SUBTYPE khrv_rec_type IS okl_contract_pub.khrv_rec_type;
11: G_ASSOCIATE_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ASSOCIATION';
12: G_PROGRAM_SCS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PROGRAM';
13: G_OPERATING_SCS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'OPERATING';
14: G_VENDOR_PROGRAM_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'VENDOR_PROGRAM';
15: G_ABANDONED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ABANDONED';
16: G_COMPLETED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'COMPLETED';
17:
18: SUBTYPE khrv_rec_type IS okl_contract_pub.khrv_rec_type;
19: SUBTYPE chrv_rec_type IS okl_okc_migration_pvt.chrv_rec_type;
12: G_PROGRAM_SCS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PROGRAM';
13: G_OPERATING_SCS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'OPERATING';
14: G_VENDOR_PROGRAM_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'VENDOR_PROGRAM';
15: G_ABANDONED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ABANDONED';
16: G_COMPLETED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'COMPLETED';
17:
18: SUBTYPE khrv_rec_type IS okl_contract_pub.khrv_rec_type;
19: SUBTYPE chrv_rec_type IS okl_okc_migration_pvt.chrv_rec_type;
20: SUBTYPE cplv_rec_type IS okl_okc_migration_pvt.cplv_rec_type;