APPS.CSM_DEBRIEF_EXPENSES_PKG dependencies on CSF_DEBRIEF_LINES

Line 83: l_issuing_inventory_org_id csf_debrief_lines.issuing_inventory_org_id%TYPE;

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

Line 84: l_receiving_inventory_org_id csf_debrief_lines.receiving_inventory_org_id%TYPE;

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

Line 280: ( b_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE

276: x_return_status IN OUT NOCOPY VARCHAR2
277: ) IS
278:
279: CURSOR c_cdl
280: ( b_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE
281: )
282: IS
283: SELECT cdl.debrief_header_id
284: , cdl.debrief_line_id

Line 287: FROM csf_debrief_lines cdl

283: SELECT cdl.debrief_header_id
284: , cdl.debrief_line_id
285: , cdl.last_update_date
286: , cdl.issuing_inventory_org_id
287: FROM csf_debrief_lines cdl
288: WHERE cdl.debrief_line_id = b_debrief_line_id;
289:
290: r_cdl c_cdl%ROWTYPE;
291: