APPS.PA_TXN_ACCUMS dependencies on PA_TXN_ACCUM_DETAILS

Line 482: FROM pa_txn_accum_details ptad

478: AND pta.system_linkage_function =
479: NVL(x_system_linkage_function,pta.system_linkage_function)
480: AND EXISTS
481: ( SELECT 'Yes'
482: FROM pa_txn_accum_details ptad
483: WHERE pta.txn_accum_id = ptad.txn_accum_id
484: AND ptad.line_type = 'C'
485: )
486: AND EXISTS

Line 546: FROM pa_txn_accum_details ptad

542: WHERE
543: pta.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id -- Commented for bug 3736097
544: AND EXISTS
545: ( SELECT 'Yes'
546: FROM pa_txn_accum_details ptad
547: WHERE pta.txn_accum_id = ptad.txn_accum_id
548: AND ptad.line_type IN ('R','E')
549: )
550: AND EXISTS

Line 611: FROM pa_txn_accum_details ptad

607: AND NVL(pta.system_linkage_function,'X') =
608: NVL(NVL(x_system_linkage_function,pta.system_linkage_function),'X')
609: AND EXISTS
610: ( SELECT 'Yes'
611: FROM pa_txn_accum_details ptad
612: WHERE pta.txn_accum_id = ptad.txn_accum_id
613: AND ptad.line_type = 'M'
614: )
615: AND EXISTS

Line 705: FROM pa_txn_accum_details ptad

701: pta.project_id BETWEEN x_start_project_id AND x_end_project_id
702: AND pta.request_id <> x_request_id
703: AND EXISTS
704: ( SELECT 'Yes'
705: FROM pa_txn_accum_details ptad
706: WHERE pta.txn_accum_id = ptad.txn_accum_id
707: AND ptad.line_type IN ('C','R','E')
708: );
709:

Line 750: DELETE pa_txn_accum_details ptad

746: pa_debug.debug('delete_act_txn_accum_details: ' || x_err_stage);
747: END IF;
748:
749: LOOP
750: DELETE pa_txn_accum_details ptad
751: WHERE txn_accum_id IN
752: (SELECT txn_accum_id FROM pa_txn_accum pta
753: WHERE
754: pta.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id -- Commented for bug 3736097

Line 820: DELETE pa_txn_accum_details ptad

816: pa_debug.debug('delete_rev_txn_accum_details: ' || x_err_stage);
817: END IF;
818:
819: LOOP
820: DELETE pa_txn_accum_details ptad
821: WHERE txn_accum_id IN
822: (SELECT txn_accum_id FROM pa_txn_accum pta
823: WHERE
824: pta.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id Commented for bug 3736097

Line 890: DELETE pa_txn_accum_details ptad

886: pa_debug.debug('delete_cmt_txn_accum_details: ' || x_err_stage);
887: END IF;
888:
889: LOOP
890: DELETE pa_txn_accum_details ptad
891: WHERE txn_accum_id IN
892: (SELECT txn_accum_id FROM pa_txn_accum pta
893: WHERE
894: pta.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id Commented out for bug 3736097

Line 950: INSERT INTO pa_txn_accum_details

946: BEGIN
947: x_err_code :=0;
948: x_err_stage := 'Creating transaction accum details';
949:
950: INSERT INTO pa_txn_accum_details
951: (txn_accum_id,
952: line_type,
953: expenditure_item_id,
954: line_num,

Line 3154: -- Create a row for drilldown in pa_txn_accum_details Now

3150: x_txn_accum_id,
3151: x_err_stage,
3152: x_err_code);
3153:
3154: -- Create a row for drilldown in pa_txn_accum_details Now
3155:
3156: create_txn_accum_details(
3157: x_txn_accum_id,
3158: 'R', -- RDLS

Line 3372: -- Create a row for drilldown in pa_txn_accum_details Now

3368: x_txn_accum_id,
3369: x_err_stage,
3370: x_err_code);
3371:
3372: -- Create a row for drilldown in pa_txn_accum_details Now
3373:
3374: create_txn_accum_details(
3375: x_txn_accum_id,
3376: 'E', -- ERDLS

Line 3675: -- Create a row for drilldown in pa_txn_accum_details Now

3671: x_txn_accum_id,
3672: x_err_stage,
3673: x_err_code);
3674:
3675: -- Create a row for drilldown in pa_txn_accum_details Now
3676:
3677: create_txn_accum_details(
3678: x_txn_accum_id,
3679: rdlrec.line_type, -- RDLS