APPS.ECE_POO_TRANSACTION dependencies on ECE_PO_DISTRIBUTIONS

Line 30: cDistribution_Interface VARCHAR2(120) := 'ECE_PO_DISTRIBUTIONS'; --Bug 1891291

26: cCommunication_Method VARCHAR2(120) := 'EDI';
27: cHeader_Interface VARCHAR2(120) := 'ECE_PO_INTERFACE_HEADERS';
28: cLine_Interface VARCHAR2(120) := 'ECE_PO_INTERFACE_LINES';
29: cShipment_Interface VARCHAR2(120) := 'ECE_PO_INTERFACE_SHIPMENTS';
30: cDistribution_Interface VARCHAR2(120) := 'ECE_PO_DISTRIBUTIONS'; --Bug 1891291
31: l_line_text VARCHAR2(2000);
32:
33: cCreat_Date_From DATE := TO_DATE(cCDate_From,'YYYY/MM/DD HH24:MI:SS');
34: cCreat_Date_To DATE := TO_DATE(cCDate_To ,'YYYY/MM/DD HH24:MI:SS') + 1;

Line 3540: v_project_view_name VARCHAR2(120) := 'ECE_PO_DISTRIBUTIONS_V'; -- Bug 1891291

3536: /* Bug 2490109
3537: l_project_tbl ece_flatfile_pvt.Interface_tbl_type;
3538: project_sel_c INTEGER;
3539: */
3540: v_project_view_name VARCHAR2(120) := 'ECE_PO_DISTRIBUTIONS_V'; -- Bug 1891291
3541:
3542: cProject_select VARCHAR2(32000);
3543: cProject_from VARCHAR2(32000);
3544: cProject_where VARCHAR2(32000);

Line 3773: /* Update ECE_PO_DISTRIBUTIONS

3769: l_project_tbl,
3770: l_project_fkey); */
3771:
3772: -- Bug 1891291 begin
3773: /* Update ECE_PO_DISTRIBUTIONS
3774: with project related data
3775: based on task_id and project_id
3776: */
3777:

Line 3795: ECE_PO_DISTRIBUTIONS EPID

3791:
3792: /* select task_id,project_id into
3793: c_task_id,c_project_id
3794: from
3795: ECE_PO_DISTRIBUTIONS EPID
3796: where
3797: EPID.TRANSACTION_RECORD_ID = l_project_fkey; */
3798:
3799:

Line 3810: ECE_PO_DISTRIBUTIONS

3806: PA_PROJECTS_EXPEND_V
3807: PPE,
3808: PA_TASKS
3809: PAT,
3810: ECE_PO_DISTRIBUTIONS
3811: EPID
3812: WHERE
3813: EPID.TASK_ID = PAT.TASK_ID (+) AND
3814: EPID.PROJECT_ID = PAT.PROJECT_ID (+) AND

Line 3824: /* UPDATE ECE_PO_DISTRIBUTIONS EPID

3820: l_project_tbl(nProject_type_pos).value := c_project_type;
3821: l_project_tbl(nTask_num_pos).value := c_task_number;
3822: --2823215
3823:
3824: /* UPDATE ECE_PO_DISTRIBUTIONS EPID
3825: SET EPID.PROJECT_NUMBER = c_PROJECT_NUMBER,
3826: EPID.PROJECT_TYPE = c_PROJECT_TYPE,
3827: EPID.TASK_NUMBER = c_TASK_NUMBER
3828: WHERE EPID.TRANSACTION_RECORD_ID = l_project_fkey; */