DBA Data[Home] [Help]

APPS.OKC_REP_CONTRACT_IMP_PUB dependencies on OKC_IMP_RECORD_TYPES

Line 11: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,

7: false: only dumps data to interface tables. The CP Impor Repository Contract has to be run to create the contract.
8: */
9:
10: Procedure create_contract(p_api_version IN NUMBER,
11: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
12: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
13: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
14: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
15: p_create_contract IN VARCHAR2 := fnd_api.g_true,

Line 12: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,

8: */
9:
10: Procedure create_contract(p_api_version IN NUMBER,
11: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
12: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
13: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
14: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
15: p_create_contract IN VARCHAR2 := fnd_api.g_true,
16: p_commit IN VARCHAR2 := fnd_api.g_false,

Line 13: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,

9:
10: Procedure create_contract(p_api_version IN NUMBER,
11: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
12: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
13: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
14: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
15: p_create_contract IN VARCHAR2 := fnd_api.g_true,
16: p_commit IN VARCHAR2 := fnd_api.g_false,
17: x_msg_data OUT NOCOPY VARCHAR2,

Line 14: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,

10: Procedure create_contract(p_api_version IN NUMBER,
11: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
12: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
13: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
14: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
15: p_create_contract IN VARCHAR2 := fnd_api.g_true,
16: p_commit IN VARCHAR2 := fnd_api.g_false,
17: x_msg_data OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,

Line 41: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

37: The relation of parent document which is obtained in p_document_rec is stored in the okc_rep_contract_usages table
38: */
39:
40: Procedure create_contract(p_api_version IN NUMBER,
41: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
42: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
43: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
44: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
45: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,

Line 42: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,

38: */
39:
40: Procedure create_contract(p_api_version IN NUMBER,
41: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
42: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
43: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
44: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
45: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
46: p_commit IN VARCHAR2 := fnd_api.g_false,

Line 43: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,

39:
40: Procedure create_contract(p_api_version IN NUMBER,
41: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
42: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
43: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
44: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
45: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
46: p_commit IN VARCHAR2 := fnd_api.g_false,
47: x_msg_data OUT NOCOPY VARCHAR2,

Line 44: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,

40: Procedure create_contract(p_api_version IN NUMBER,
41: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
42: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
43: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
44: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
45: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
46: p_commit IN VARCHAR2 := fnd_api.g_false,
47: x_msg_data OUT NOCOPY VARCHAR2,
48: x_msg_count OUT NOCOPY NUMBER,

Line 45: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,

41: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
42: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
43: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
44: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
45: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
46: p_commit IN VARCHAR2 := fnd_api.g_false,
47: x_msg_data OUT NOCOPY VARCHAR2,
48: x_msg_count OUT NOCOPY NUMBER,
49: x_return_status OUT NOCOPY VARCHAR2

Line 57: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

53: Deletes the Contract for the given document type.
54: */
55:
56: Procedure delete_contract(p_api_version IN NUMBER,
57: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
58: p_contract_type IN VARCHAR2 DEFAULT NULL,
59: p_contract_id IN NUMBER DEFAULT NULL,
60: p_commit IN VARCHAR2 := fnd_api.g_false,
61: x_msg_data OUT NOCOPY VARCHAR2,

Line 88: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

84: The relation of parent document which is obtained in p_document_rec is stored in the okc_rep_contract_usages table
85: */
86:
87: Procedure create_new_contract_version(p_api_version IN NUMBER,
88: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
89: p_contract_type IN VARCHAR2 DEFAULT NULL,
90: p_contract_id IN NUMBER DEFAULT NULL,
91: p_commit IN VARCHAR2 := fnd_api.g_false,
92: x_msg_data OUT NOCOPY VARCHAR2,

Line 98: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

94: x_return_status OUT NOCOPY VARCHAR2
95: );
96:
97: PROCEDURE check_contract_exists(p_api_version IN NUMBER,
98: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
99: x_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_return_status OUT NOCOPY VARCHAR2

Line 99: x_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,

95: );
96:
97: PROCEDURE check_contract_exists(p_api_version IN NUMBER,
98: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
99: x_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_return_status OUT NOCOPY VARCHAR2
103: );

Line 106: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

102: x_return_status OUT NOCOPY VARCHAR2
103: );
104:
105: PROCEDURE Activate_tasks_closeout(p_api_version IN NUMBER,
106: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
107: p_physical_completion_date IN DATE ,
108: p_init_msg_list IN VARCHAR2,
109: p_commit IN VARCHAR2,
110: x_msg_data OUT NOCOPY VARCHAR2,

Line 120: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

116: Cancels the Contract for the given document type.
117: */
118:
119: Procedure cancel_contract(p_api_version IN NUMBER,
120: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
121: p_contract_type IN VARCHAR2 DEFAULT NULL,
122: p_contract_id IN NUMBER DEFAULT NULL,
123: p_commit IN VARCHAR2 := fnd_api.g_false,
124: x_msg_data OUT NOCOPY VARCHAR2,

Line 139: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

135: );
136:
137: Procedure delete_cancel_contract(p_api_version IN NUMBER,
138: p_commit IN VARCHAR2 := fnd_api.g_false,
139: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
140: p_contract_type IN VARCHAR2 DEFAULT NULL,
141: p_contract_id IN NUMBER DEFAULT NULL,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,