APPS.PA_BILLING_SETUP_PVT dependencies on PA_PROJECTS

Line 81: l_retention_percent PA_PROJECTS_ALL.RETENTION_PERCENTAGE%TYPE;

77: l_next_billing_date DATE;
78: l_output_tax_code VARCHAR2(50);
79: l_invoice_comment VARCHAR2(240);
80: l_retention_inv_format_id NUMBER(15);
81: l_retention_percent PA_PROJECTS_ALL.RETENTION_PERCENTAGE%TYPE;
82: l_retention_output_tax_code VARCHAR2(50);
83: l_project_type_class_code PA_PROJECT_TYPES.PROJECT_TYPE_CLASS_CODE%TYPE;
84:
85:

Line 176: /* Lock pa_projects table and update */

172: THEN
173: pa_debug.debug('Update_reve_and_billing PVT: Checking Lock on record');
174: END IF;
175:
176: /* Lock pa_projects table and update */
177: IF p_validate_only <> FND_API.G_TRUE
178: THEN
179: BEGIN
180: SELECT 'x' INTO l_dummy_char

Line 181: FROM pa_projects

177: IF p_validate_only <> FND_API.G_TRUE
178: THEN
179: BEGIN
180: SELECT 'x' INTO l_dummy_char
181: FROM pa_projects
182: WHERE project_id = p_project_id
183: AND record_version_number = p_record_version_number
184: FOR UPDATE OF record_version_number NOWAIT;
185: EXCEPTION

Line 215: FROM pa_projects

211: END;
212: ELSE
213: BEGIN
214: SELECT 'x' INTO l_dummy_char
215: FROM pa_projects
216: WHERE project_id = p_project_id
217: AND record_version_number = p_record_version_number;
218: EXCEPTION
219: WHEN NO_DATA_FOUND THEN

Line 248: UPDATE pa_projects

244: RAISE FND_API.G_EXC_ERROR;
245: END IF;
246:
247:
248: UPDATE pa_projects
249: SET DISTRIBUTION_RULE = p_distribution_rule,
250: BILLING_CYCLE_ID = p_billing_cycle_id,
251: BILLING_OFFSET = l_first_bill_offset,
252: OUTPUT_TAX_CODE = l_output_tax_code,

Line 1048: FROM pa_projects_all

1044:
1045: CURSOR cur_proj_all
1046: IS
1047: SELECT org_id, distribution_rule, project_type
1048: FROM pa_projects_all
1049: WHERE project_id = p_project_id;
1050:
1051: l_return_status VARCHAR2(1);
1052: l_error_msg_code VARCHAR2(250);