APPS.CSFW_DEBRIEF_PUB dependencies on CSF_DEBRIEF_LINES

Line 191: cursor c_dbf_line_id is select CSF_DEBRIEF_LINES_S.nextval from dual;

187:
188: r_find_resource find_resource%ROWTYPE;
189:
190:
191: cursor c_dbf_line_id is select CSF_DEBRIEF_LINES_S.nextval from dual;
192:
193: cursor c_uom_code(v_org_id number, v_item_id number)
194: is
195: select primary_uom_code from mtl_system_items_vl

Line 565: cursor c_dbf_lineId is select CSF_DEBRIEF_LINES_S.nextval from dual;

561: l_expenditure_org_id number;
562: l_project_id number;
563: l_project_task_id number;
564:
565: cursor c_dbf_lineId is select CSF_DEBRIEF_LINES_S.nextval from dual;
566: cursor c_uom_code (v_org_id number, v_item_id number)
567: is
568: select primary_uom_code from mtl_system_items_vl
569: where organization_id = v_org_id

Line 855: select DEBRIEF_HEADER_ID from CSF_DEBRIEF_LINES where DEBRIEF_LINE_ID =

851: l_project_id number;
852: l_project_task_id number;
853:
854: cursor c_DEBRIEF_HEADER_ID(v_debrief_line_id number ) is
855: select DEBRIEF_HEADER_ID from CSF_DEBRIEF_LINES where DEBRIEF_LINE_ID =
856: v_debrief_line_id ;
857:
858: cursor c_uom_code(v_org_id number, v_item_id number) is
859: select primary_uom_code from mtl_system_items_vl

Line 1152: select DEBRIEF_HEADER_ID from CSF_DEBRIEF_LINES where DEBRIEF_LINE_ID =

1148: l_project_id number;
1149: l_project_task_id number;
1150:
1151: cursor c_DEBRIEF_HEADER_ID(v_debrief_line_id number ) is
1152: select DEBRIEF_HEADER_ID from CSF_DEBRIEF_LINES where DEBRIEF_LINE_ID =
1153: v_debrief_line_id;
1154:
1155: cursor c_uom_code(v_org_id number, v_item_id number) is
1156: select primary_uom_code from mtl_system_items_vl

Line 1719: cursor c_dbf_lines is select CSF_DEBRIEF_LINES_S.nextval from dual;

1715: cursor c_DEBRIEF_HEADER_ID(v_dbf_nr varchar2) is
1716: select DEBRIEF_HEADER_ID from csf_debrief_headers where debrief_number = v_dbf_nr;
1717:
1718:
1719: cursor c_dbf_lines is select CSF_DEBRIEF_LINES_S.nextval from dual;
1720:
1721: cursor c_status_name(v_partStatusCd varchar2) is
1722: select name
1723: from csi_instance_statuses

Line 2383: ( b_dbfLineId csf_debrief_lines.DEBRIEF_LINE_ID%TYPE

2379: and lookup_code = p_code;
2380:
2381:
2382: CURSOR c_dbfLineRec
2383: ( b_dbfLineId csf_debrief_lines.DEBRIEF_LINE_ID%TYPE
2384: )
2385: IS
2386: SELECT BUSINESS_PROCESS_ID
2387: , inventory_item_id

Line 2477: CSF_DEBRIEF_LINES_PKG.Update_Row(

2473: open c_status_meaning(l_interface_status);
2474: fetch c_status_meaning INTO l_interface_status_meaning;
2475: close c_status_meaning;
2476:
2477: CSF_DEBRIEF_LINES_PKG.Update_Row(
2478: p_DEBRIEF_LINE_ID => p_dbfLineId,
2479: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
2480: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
2481: p_SERVICE_DATE => FND_API.G_MISS_DATE,

Line 2649: ( b_dbfLineId csf_debrief_lines.DEBRIEF_LINE_ID%TYPE

2645:
2646:
2647:
2648: CURSOR c_dbfLineRec
2649: ( b_dbfLineId csf_debrief_lines.DEBRIEF_LINE_ID%TYPE
2650: )
2651: IS
2652: SELECT service_date
2653: , DEBRIEF_HEADER_ID

Line 2670: cursor c_ib_rec (b_dbfLineId csf_debrief_lines.DEBRIEF_LINE_ID%TYPE) is

2666: r_dbfLineRec c_dbfLineRec%ROWTYPE;
2667:
2668:
2669:
2670: cursor c_ib_rec (b_dbfLineId csf_debrief_lines.DEBRIEF_LINE_ID%TYPE) is
2671: select
2672: ctst.sub_type_id sub_type_id ,
2673: ctst.transaction_type_id transaction_type_id_csi ,
2674: cttv.line_order_category_code line_order_category_code

Line 2844: CSF_DEBRIEF_LINES_PKG.Update_Row(

2840: open c_status_meaning(l_interface_status);
2841: fetch c_status_meaning INTO l_interface_status_meaning;
2842: close c_status_meaning;
2843:
2844: CSF_DEBRIEF_LINES_PKG.Update_Row(
2845: p_DEBRIEF_LINE_ID => p_dbfLineId,
2846: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
2847: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
2848: p_SERVICE_DATE => FND_API.G_MISS_DATE,

Line 2968: ( b_dbfLineId csf_debrief_lines.DEBRIEF_LINE_ID%TYPE

2964: and lookup_code = p_code;
2965:
2966:
2967: CURSOR c_dbfLineRec
2968: ( b_dbfLineId csf_debrief_lines.DEBRIEF_LINE_ID%TYPE
2969: )
2970: IS
2971: SELECT DEBRIEF_HEADER_ID
2972: , inventory_item_id

Line 2990: cursor c_ib_rec (b_dbfLineId csf_debrief_lines.DEBRIEF_LINE_ID%TYPE) is

2986: r_dbfLineRec c_dbfLineRec%ROWTYPE;
2987:
2988:
2989:
2990: cursor c_ib_rec (b_dbfLineId csf_debrief_lines.DEBRIEF_LINE_ID%TYPE) is
2991: select
2992: ctst.sub_type_id sub_type_id ,
2993: ctst.transaction_type_id transaction_type_id_csi ,
2994: cttv.line_order_category_code line_order_category_code

Line 3116: CSF_DEBRIEF_LINES_PKG.Update_Row(

3112: open c_status_meaning(l_interface_status);
3113: fetch c_status_meaning INTO l_interface_status_meaning;
3114: close c_status_meaning;
3115:
3116: CSF_DEBRIEF_LINES_PKG.Update_Row(
3117: p_DEBRIEF_LINE_ID => p_dbfLineId,
3118: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
3119: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
3120: p_SERVICE_DATE => FND_API.G_MISS_DATE,