APPS.CSM_DEBRIEF_LABOR_PKG dependencies on CSF_DEBRIEF_LINES

Line 84: l_issuing_inventory_org_id csf_debrief_lines.issuing_inventory_org_id%TYPE;

80:
81: l_debrief_header_id number;
82: l_date date := sysdate;
83:
84: l_issuing_inventory_org_id csf_debrief_lines.issuing_inventory_org_id%TYPE;
85: l_receiving_inventory_org_id csf_debrief_lines.receiving_inventory_org_id%TYPE;
86:
87: l_msg_data varchar2(1024);
88: l_msg_count number;

Line 85: l_receiving_inventory_org_id csf_debrief_lines.receiving_inventory_org_id%TYPE;

81: l_debrief_header_id number;
82: l_date date := sysdate;
83:
84: l_issuing_inventory_org_id csf_debrief_lines.issuing_inventory_org_id%TYPE;
85: l_receiving_inventory_org_id csf_debrief_lines.receiving_inventory_org_id%TYPE;
86:
87: l_msg_data varchar2(1024);
88: l_msg_count number;
89:

Line 283: CURSOR c_cdl( b_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE )

279: p_error_msg OUT NOCOPY VARCHAR2,
280: x_return_status IN OUT NOCOPY VARCHAR2
281: ) IS
282:
283: CURSOR c_cdl( b_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE )
284: IS
285: SELECT cdl.debrief_header_id
286: , cdl.debrief_line_id
287: , cdl.last_update_date

Line 289: FROM csf_debrief_lines cdl

285: SELECT cdl.debrief_header_id
286: , cdl.debrief_line_id
287: , cdl.last_update_date
288: , cdl.issuing_inventory_org_id
289: FROM csf_debrief_lines cdl
290: WHERE cdl.debrief_line_id = b_debrief_line_id;
291:
292: r_cdl c_cdl%ROWTYPE;
293: l_line_rec csf_debrief_pub.debrief_line_rec_type;