DBA Data[Home] [Help]

APPS.OKS_RENCPY_PVT dependencies on OKC_API

Line 34: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

30:
31: ---------------------------------------------------------------------------
32: -- GLOBAL MESSAGE CONSTANTS
33: ---------------------------------------------------------------------------
34: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
35: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
36: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
37: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
38: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 35: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

31: ---------------------------------------------------------------------------
32: -- GLOBAL MESSAGE CONSTANTS
33: ---------------------------------------------------------------------------
34: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
35: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
36: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
37: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
38: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
39: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 36: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

32: -- GLOBAL MESSAGE CONSTANTS
33: ---------------------------------------------------------------------------
34: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
35: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
36: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
37: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
38: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
39: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
40: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

Line 37: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

33: ---------------------------------------------------------------------------
34: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
35: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
36: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
37: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
38: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
39: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
40: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
41: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 38: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

34: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
35: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
36: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
37: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
38: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
39: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
40: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
41: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
42: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 39: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

35: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
36: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
37: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
38: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
39: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
40: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
41: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
42: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
43: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 40: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

36: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
37: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
38: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
39: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
40: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
41: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
42: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
43: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
44: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';

Line 41: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

37: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
38: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
39: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
40: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
41: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
42: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
43: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
44: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
45: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 42: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

38: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
39: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
40: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
41: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
42: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
43: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
44: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
45: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
46: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 43: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

39: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
40: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
41: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
42: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
43: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
44: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
45: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
46: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
47: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQ';

Line 59: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

55:
56: -- GLOBAL VARIABLES
57: ---------------------------------------------------------------------------
58: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_COPY_CONTRACT_PVT';
59: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
60: g_klnv_rec klnv_rec_type;
61: ---------------------------------------------------------------------------
62:
63: TYPE api_components_rec IS RECORD(id NUMBER,

Line 85: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

81:
82:
83: PROCEDURE copy_contract_line(
84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
89: p_from_cle_id IN NUMBER,

Line 91: p_to_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
89: p_from_cle_id IN NUMBER,
90: p_from_chr_id IN NUMBER,
91: p_to_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
92: p_to_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
93: p_lse_id IN NUMBER,
94: p_to_template_yn IN VARCHAR2,
95: p_copy_reference IN VARCHAR2 DEFAULT 'COPY',

Line 92: p_to_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

88: x_msg_data OUT NOCOPY VARCHAR2,
89: p_from_cle_id IN NUMBER,
90: p_from_chr_id IN NUMBER,
91: p_to_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
92: p_to_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
93: p_lse_id IN NUMBER,
94: p_to_template_yn IN VARCHAR2,
95: p_copy_reference IN VARCHAR2 DEFAULT 'COPY',
96: p_copy_line_party_yn IN VARCHAR2,

Line 103: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

99: x_cle_id OUT NOCOPY NUMBER);
100:
101: PROCEDURE copy_party_roles(
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_cpl_id IN NUMBER,

Line 108: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_cpl_id IN NUMBER,
108: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
109: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
110: p_rle_code IN VARCHAR2,
111: x_cpl_id OUT NOCOPY NUMBER);
112:

Line 109: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_cpl_id IN NUMBER,
108: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
109: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
110: p_rle_code IN VARCHAR2,
111: x_cpl_id OUT NOCOPY NUMBER);
112:
113: PROCEDURE copy_articles(

Line 115: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

111: x_cpl_id OUT NOCOPY NUMBER);
112:
113: PROCEDURE copy_articles(
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,
119: p_cat_id IN NUMBER,

Line 120: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,
119: p_cat_id IN NUMBER,
120: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
121: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
122: x_cat_id OUT NOCOPY NUMBER);
123:
124:

Line 121: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,
119: p_cat_id IN NUMBER,
120: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
121: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
122: x_cat_id OUT NOCOPY NUMBER);
123:
124:
125: PROCEDURE copy_rules(

Line 127: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

123:
124:
125: PROCEDURE copy_rules(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_old_cle_id IN NUMBER,

Line 132: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_old_cle_id IN NUMBER,
132: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
133: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
134: p_cust_acct_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
135: p_bill_to_site_use_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
136: p_to_template_yn IN VARCHAR2);

Line 133: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_old_cle_id IN NUMBER,
132: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
133: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
134: p_cust_acct_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
135: p_bill_to_site_use_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
136: p_to_template_yn IN VARCHAR2);
137:

Line 134: p_cust_acct_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_old_cle_id IN NUMBER,
132: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
133: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
134: p_cust_acct_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
135: p_bill_to_site_use_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
136: p_to_template_yn IN VARCHAR2);
137:
138:

Line 135: p_bill_to_site_use_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

131: p_old_cle_id IN NUMBER,
132: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
133: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
134: p_cust_acct_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
135: p_bill_to_site_use_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
136: p_to_template_yn IN VARCHAR2);
137:
138:
139: PROCEDURE create_trxn_extn(

Line 141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

137:
138:
139: PROCEDURE create_trxn_extn(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_old_trx_ext_id IN NUMBER,