APPS.CSM_DEBRIEF_EXPENSES_PKG dependencies on CSF_DEBRIEF_LINES

Line 82: l_issuing_inventory_org_id csf_debrief_lines.issuing_inventory_org_id%TYPE;

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

Line 83: l_receiving_inventory_org_id csf_debrief_lines.receiving_inventory_org_id%TYPE;

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

Line 277: ( b_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE

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

Line 284: FROM csf_debrief_lines cdl

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