APPS.CSM_DEBRIEF_EVENT_PKG dependencies on CSM_PROFILE_PKG

Line 62: AND msi.organization_id = NVL(NVL(lines.issuing_inventory_org_id, lines.receiving_inventory_org_id), csm_profile_pkg.get_organization_id(p_user_id))

58: cs_txn_billing_types txbt,
59: CS_BILLING_TYPE_CATEGORIES cbtc
60: WHERE lines.debrief_line_id = p_debrief_line_id
61: AND msi.inventory_item_id = lines.inventory_item_id
62: AND msi.organization_id = NVL(NVL(lines.issuing_inventory_org_id, lines.receiving_inventory_org_id), csm_profile_pkg.get_organization_id(p_user_id))
63: AND lines.transaction_type_id = txbt.transaction_type_id
64: AND msi.material_billable_flag = txbt.billing_type
65: AND txbt.billing_type = cbtc.billing_type;
66:

Line 162: NVL(NVL(issuing_inventory_org_id, receiving_inventory_org_id), csm_profile_pkg.get_organization_id(jtrs.user_id)) AS organization_id

158:
159: CURSOR l_csm_debrfLnInsInit_csr (p_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE)
160: IS
161: SELECT dhdr.task_assignment_id, jtrs.user_id, jta.resource_id ,dbl.inventory_item_id, dbl.instance_id,
162: NVL(NVL(issuing_inventory_org_id, receiving_inventory_org_id), csm_profile_pkg.get_organization_id(jtrs.user_id)) AS organization_id
163: FROM csf_debrief_lines dbl,
164: csf_debrief_headers dhdr,
165: jtf_task_assignments jta,
166: jtf_rs_resource_extns jtrs

Line 200: l_labor_exp_organization_id := csm_profile_pkg.get_organization_id(l_user_id);

196: l_user_id := l_csm_debrfLnInsInit_rec.user_id;
197: l_labor_exp_organization_id := l_csm_debrfLnInsInit_rec.organization_id;
198: ELSE
199: l_user_id := p_h_user_id;
200: l_labor_exp_organization_id := csm_profile_pkg.get_organization_id(l_user_id);
201: END IF;
202:
203: -- get material billable flag of the debrief line
204: l_material_billable_flag := material_billable_flag(p_debrief_line_id=>p_debrief_line_id,

Line 257: NVL(NVL(dbl.issuing_inventory_org_id, dbl.receiving_inventory_org_id), csm_profile_pkg.get_organization_id(p_user_id)) AS organization_id

253:
254: CURSOR l_csm_debrfLnDel_csr (p_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE, p_user_id IN NUMBER)
255: IS
256: SELECT acc.user_id, dbl.inventory_item_id, dbl.instance_id,
257: NVL(NVL(dbl.issuing_inventory_org_id, dbl.receiving_inventory_org_id), csm_profile_pkg.get_organization_id(p_user_id)) AS organization_id
258: FROM csf_debrief_lines dbl,
259: csm_debrief_lines_acc acc
260: WHERE dbl.debrief_line_id = p_debrief_line_id
261: AND acc.debrief_line_id = dbl.debrief_line_id

Line 365: NVL(nvl(issuing_inventory_org_id, receiving_inventory_org_id), csm_profile_pkg.get_organization_id(jtrs.user_id)) AS organization_id,

361: jtrs.user_id,
362: jta.resource_id,
363: dbl.inventory_item_id,
364: dbl.instance_id,
365: NVL(nvl(issuing_inventory_org_id, receiving_inventory_org_id), csm_profile_pkg.get_organization_id(jtrs.user_id)) AS organization_id,
366: acc.access_id
367: FROM csf_debrief_lines dbl,
368: csf_debrief_headers dhdr,
369: csm_debrief_lines_acc acc,