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 3573: v_project_view_name VARCHAR2(120) := 'ECE_PO_DISTRIBUTIONS_V'; -- Bug 1891291

3569: /* Bug 2490109
3570: l_project_tbl ece_flatfile_pvt.Interface_tbl_type;
3571: project_sel_c INTEGER;
3572: */
3573: v_project_view_name VARCHAR2(120) := 'ECE_PO_DISTRIBUTIONS_V'; -- Bug 1891291
3574:
3575: cProject_select VARCHAR2(32000);
3576: cProject_from VARCHAR2(32000);
3577: cProject_where VARCHAR2(32000);

Line 3806: /* Update ECE_PO_DISTRIBUTIONS

3802: l_project_tbl,
3803: l_project_fkey); */
3804:
3805: -- Bug 1891291 begin
3806: /* Update ECE_PO_DISTRIBUTIONS
3807: with project related data
3808: based on task_id and project_id
3809: */
3810:

Line 3828: ECE_PO_DISTRIBUTIONS EPID

3824:
3825: /* select task_id,project_id into
3826: c_task_id,c_project_id
3827: from
3828: ECE_PO_DISTRIBUTIONS EPID
3829: where
3830: EPID.TRANSACTION_RECORD_ID = l_project_fkey; */
3831:
3832:

Line 3843: ECE_PO_DISTRIBUTIONS

3839: PA_PROJECTS_EXPEND_V
3840: PPE,
3841: PA_TASKS
3842: PAT,
3843: ECE_PO_DISTRIBUTIONS
3844: EPID
3845: WHERE
3846: EPID.TASK_ID = PAT.TASK_ID (+) AND
3847: EPID.PROJECT_ID = PAT.PROJECT_ID (+) AND

Line 3857: /* UPDATE ECE_PO_DISTRIBUTIONS EPID

3853: l_project_tbl(nProject_type_pos).value := c_project_type;
3854: l_project_tbl(nTask_num_pos).value := c_task_number;
3855: --2823215
3856:
3857: /* UPDATE ECE_PO_DISTRIBUTIONS EPID
3858: SET EPID.PROJECT_NUMBER = c_PROJECT_NUMBER,
3859: EPID.PROJECT_TYPE = c_PROJECT_TYPE,
3860: EPID.TASK_NUMBER = c_TASK_NUMBER
3861: WHERE EPID.TRANSACTION_RECORD_ID = l_project_fkey; */