APPS.CSM_DEBRIEF_PARTS_PKG dependencies on CSF_DEBRIEF_LINES

Line 153: l_issuing_inventory_org_id csf_debrief_lines.issuing_inventory_org_id%TYPE;

149: l_debrief_header_id number;
150: l_debrief_number number;
151: l_date date := sysdate;
152:
153: l_issuing_inventory_org_id csf_debrief_lines.issuing_inventory_org_id%TYPE;
154:
155: l_msg_data varchar2(1024);
156: l_msg_count number;
157:

Line 163: l_spare_update_status csf_debrief_lines.spare_update_status%TYPE;

159: l_transaction_header_id number;
160: l_transaction_type_id NUMBER;
161: l_line_order_category_code VARCHAR2(100);
162:
163: l_spare_update_status csf_debrief_lines.spare_update_status%TYPE;
164: l_freeform VARCHAR2(255);
165: l_responsibility_id NUMBER;
166: l_csm_appl_id fnd_application.application_id%TYPE;
167: l_CS_INV_ORG_ID NUMBER;

Line 551: CURSOR c_cdl( b_debrief_line_number csf_debrief_lines.debrief_line_number%TYPE )

547: x_return_status IN out nocopy VARCHAR2
548: ) IS
549:
550: --CURSOR Declarations
551: CURSOR c_cdl( b_debrief_line_number csf_debrief_lines.debrief_line_number%TYPE )
552: IS
553: SELECT cdl.debrief_header_id
554: , cdl.debrief_line_id
555: , cdl.last_update_date

Line 557: from CSF_DEBRIEF_LINES CDL

553: SELECT cdl.debrief_header_id
554: , cdl.debrief_line_id
555: , cdl.last_update_date
556: , cdl.issuing_inventory_org_id
557: from CSF_DEBRIEF_LINES CDL
558: WHERE cdl.debrief_line_number = b_debrief_line_number;
559:
560: CURSOR c_cdline( b_debrief_line_num csf_debrief_lines.debrief_line_number%TYPE )
561: IS

Line 560: CURSOR c_cdline( b_debrief_line_num csf_debrief_lines.debrief_line_number%TYPE )

556: , cdl.issuing_inventory_org_id
557: from CSF_DEBRIEF_LINES CDL
558: WHERE cdl.debrief_line_number = b_debrief_line_number;
559:
560: CURSOR c_cdline( b_debrief_line_num csf_debrief_lines.debrief_line_number%TYPE )
561: IS
562: SELECT cdl.debrief_line_id
563: from CSF_DEBRIEF_LINES CDL
564: where CDL.DEBRIEF_LINE_NUMBER = b_debrief_line_num;

Line 563: from CSF_DEBRIEF_LINES CDL

559:
560: CURSOR c_cdline( b_debrief_line_num csf_debrief_lines.debrief_line_number%TYPE )
561: IS
562: SELECT cdl.debrief_line_id
563: from CSF_DEBRIEF_LINES CDL
564: where CDL.DEBRIEF_LINE_NUMBER = b_debrief_line_num;
565:
566: --VARIABLE Declarations
567: r_cdl c_cdl%ROWTYPE;

Line 570: l_issuing_inventory_org_id csf_debrief_lines.issuing_inventory_org_id%TYPE;

566: --VARIABLE Declarations
567: r_cdl c_cdl%ROWTYPE;
568:
569: l_line_rec csf_debrief_pub.debrief_line_rec_type;
570: l_issuing_inventory_org_id csf_debrief_lines.issuing_inventory_org_id%TYPE;
571: l_spare_update_status csf_debrief_lines.spare_update_status%TYPE;
572:
573: l_debrief_header_id NUMBER;
574: l_debrief_number NUMBER;

Line 571: l_spare_update_status csf_debrief_lines.spare_update_status%TYPE;

567: r_cdl c_cdl%ROWTYPE;
568:
569: l_line_rec csf_debrief_pub.debrief_line_rec_type;
570: l_issuing_inventory_org_id csf_debrief_lines.issuing_inventory_org_id%TYPE;
571: l_spare_update_status csf_debrief_lines.spare_update_status%TYPE;
572:
573: l_debrief_header_id NUMBER;
574: l_debrief_number NUMBER;
575: l_date DATE := SYSDATE;