APPS.PA_IC_INV_CNL dependencies on PA_DRAFT_INVOICE_DETAILS

Line 49: l_inv_detail_rec pa_draft_invoice_details%rowtype;

45: l_TP_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
46: l_TP_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
47: l_TP_RULE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
48:
49: l_inv_detail_rec pa_draft_invoice_details%rowtype;
50:
51:
52: /* Bug 5082249 : Performance Issue : FTS
53: Fix : Added the project_id in the subquery */

Line 58: from pa_draft_invoice_details did

54:
55: cursor c_invoice_detail (p_proj_id number,
56: p_inv_num number) is
57: select *
58: from pa_draft_invoice_details did
59: where project_id = p_proj_id
60: and draft_invoice_num = p_inv_num
61: and not exists
62: ( select 'x'

Line 63: from pa_draft_invoice_details did1

59: where project_id = p_proj_id
60: and draft_invoice_num = p_inv_num
61: and not exists
62: ( select 'x'
63: from pa_draft_invoice_details did1
64: where did1.project_id = p_proj_id
65: and did1.detail_id_reversed = did.draft_invoice_detail_id) ;
66:
67: CANNOT_ACQUIRE_LOCK exception;

Line 452: UPDATE PA_DRAFT_INVOICE_DETAILS

448: /* Update the existing reversing invoice details ,
449: these rows will already have the columns orig_draft_invoice_num
450: and orig_draft_invoice_line_num populated */
451:
452: UPDATE PA_DRAFT_INVOICE_DETAILS
453: SET DRAFT_INVOICE_NUM = l_new_draft_inv_num ,
454: DRAFT_INVOICE_LINE_NUM = ORIG_DRAFT_INVOICE_LINE_NUM,
455: INVOICED_FLAG = 'Y',
456: last_update_date = SYSDATE,