DBA Data[Home] [Help]

APPS.CSM_DEBRIEF_LABOR_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 281: ( b_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE

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

Line 288: FROM csf_debrief_lines cdl

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