APPS.CSFW_DEBRIEF_PUB dependencies on CSF_DEBRIEF_LINES

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

148:
149: r_find_resource find_resource%ROWTYPE;
150:
151:
152: cursor c_dbf_line_id is select CSF_DEBRIEF_LINES_S.nextval from dual;
153:
154: cursor c_uom_code(v_org_id number, v_item_id number)
155: is
156: select primary_uom_code from mtl_system_items_vl

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

363: l_estimate_detail_id NUMBER;
364: l_line_number NUMBER;
365: l_charge_Entry VARCHAR2(1);
366:
367: cursor c_dbf_lineId is select CSF_DEBRIEF_LINES_S.nextval from dual;
368: cursor c_uom_code (v_org_id number, v_item_id number)
369: is
370: select primary_uom_code from mtl_system_items_vl
371: where organization_id = v_org_id

Line 504: select DEBRIEF_HEADER_ID from CSF_DEBRIEF_LINES where DEBRIEF_LINE_ID =

500: l_line_number NUMBER;
501: l_charge_Entry VARCHAR2(1);
502:
503: cursor c_DEBRIEF_HEADER_ID(v_debrief_line_id number ) is
504: select DEBRIEF_HEADER_ID from CSF_DEBRIEF_LINES where DEBRIEF_LINE_ID =
505: v_debrief_line_id ;
506:
507: cursor c_uom_code(v_org_id number, v_item_id number) is
508: select primary_uom_code from mtl_system_items_vl

Line 643: select DEBRIEF_HEADER_ID from CSF_DEBRIEF_LINES where DEBRIEF_LINE_ID =

639: l_sr_date DATE;
640: l_charge_Entry varchar2(1);
641:
642: cursor c_DEBRIEF_HEADER_ID(v_debrief_line_id number ) is
643: select DEBRIEF_HEADER_ID from CSF_DEBRIEF_LINES where DEBRIEF_LINE_ID =
644: v_debrief_line_id;
645:
646: cursor c_uom_code(v_org_id number, v_item_id number) is
647: select primary_uom_code from mtl_system_items_vl

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

1031: cursor c_DEBRIEF_HEADER_ID(v_dbf_nr varchar2) is
1032: select DEBRIEF_HEADER_ID from csf_debrief_headers where debrief_number = v_dbf_nr;
1033:
1034:
1035: cursor c_dbf_lines is select CSF_DEBRIEF_LINES_S.nextval from dual;
1036:
1037: cursor c_status_name(v_partStatusCd varchar2) is
1038: select name
1039: from csi_instance_statuses

Line 1534: ( b_dbfLineId csf_debrief_lines.DEBRIEF_LINE_ID%TYPE

1530: and lookup_code = p_code;
1531:
1532:
1533: CURSOR c_dbfLineRec
1534: ( b_dbfLineId csf_debrief_lines.DEBRIEF_LINE_ID%TYPE
1535: )
1536: IS
1537: SELECT BUSINESS_PROCESS_ID
1538: , inventory_item_id

Line 1628: CSF_DEBRIEF_LINES_PKG.Update_Row(

1624: open c_status_meaning(l_interface_status);
1625: fetch c_status_meaning INTO l_interface_status_meaning;
1626: close c_status_meaning;
1627:
1628: CSF_DEBRIEF_LINES_PKG.Update_Row(
1629: p_DEBRIEF_LINE_ID => p_dbfLineId,
1630: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
1631: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
1632: p_SERVICE_DATE => FND_API.G_MISS_DATE,

Line 1800: ( b_dbfLineId csf_debrief_lines.DEBRIEF_LINE_ID%TYPE

1796:
1797:
1798:
1799: CURSOR c_dbfLineRec
1800: ( b_dbfLineId csf_debrief_lines.DEBRIEF_LINE_ID%TYPE
1801: )
1802: IS
1803: SELECT service_date
1804: , DEBRIEF_HEADER_ID

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

1817: r_dbfLineRec c_dbfLineRec%ROWTYPE;
1818:
1819:
1820:
1821: cursor c_ib_rec (b_dbfLineId csf_debrief_lines.DEBRIEF_LINE_ID%TYPE) is
1822: select
1823: ctst.sub_type_id sub_type_id ,
1824: ctst.transaction_type_id transaction_type_id_csi ,
1825: cttv.line_order_category_code line_order_category_code

Line 1995: CSF_DEBRIEF_LINES_PKG.Update_Row(

1991: open c_status_meaning(l_interface_status);
1992: fetch c_status_meaning INTO l_interface_status_meaning;
1993: close c_status_meaning;
1994:
1995: CSF_DEBRIEF_LINES_PKG.Update_Row(
1996: p_DEBRIEF_LINE_ID => p_dbfLineId,
1997: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
1998: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
1999: p_SERVICE_DATE => FND_API.G_MISS_DATE,

Line 2119: ( b_dbfLineId csf_debrief_lines.DEBRIEF_LINE_ID%TYPE

2115: and lookup_code = p_code;
2116:
2117:
2118: CURSOR c_dbfLineRec
2119: ( b_dbfLineId csf_debrief_lines.DEBRIEF_LINE_ID%TYPE
2120: )
2121: IS
2122: SELECT DEBRIEF_HEADER_ID
2123: , inventory_item_id

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

2137: r_dbfLineRec c_dbfLineRec%ROWTYPE;
2138:
2139:
2140:
2141: cursor c_ib_rec (b_dbfLineId csf_debrief_lines.DEBRIEF_LINE_ID%TYPE) is
2142: select
2143: ctst.sub_type_id sub_type_id ,
2144: ctst.transaction_type_id transaction_type_id_csi ,
2145: cttv.line_order_category_code line_order_category_code

Line 2267: CSF_DEBRIEF_LINES_PKG.Update_Row(

2263: open c_status_meaning(l_interface_status);
2264: fetch c_status_meaning INTO l_interface_status_meaning;
2265: close c_status_meaning;
2266:
2267: CSF_DEBRIEF_LINES_PKG.Update_Row(
2268: p_DEBRIEF_LINE_ID => p_dbfLineId,
2269: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
2270: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
2271: p_SERVICE_DATE => FND_API.G_MISS_DATE,