eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_DEBRIEF_EVENT_PKG dependencies on CSF_DEBRIEF_LINES

Line 5: g_debrief_table_name CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_LINES';

1: PACKAGE BODY CSM_DEBRIEF_EVENT_PKG AS
2: /* $Header: csmedebb.pls 120.2.12020000.2 2013/04/09 10:53:51 saradhak ship $ */
3:
4: g_debrief_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_DEBRIEF_LINES_ACC';
5: g_debrief_table_name CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_LINES';
6: g_debrief_seq_name CONSTANT VARCHAR2(30) := 'CSM_DEBRIEF_LINES_ACC_S';
7: g_debrief_pk1_name CONSTANT VARCHAR2(30) := 'DEBRIEF_LINE_ID';
8: g_debrief_pubi_name CSM_ACC_PKG.t_publication_item_list;
9: g_labor_billing_type_category CONSTANT VARCHAR2(30) := 'L';

Line 53: CURSOR l_txn_billing_csr(p_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE, p_user_id IN NUMBER)

49: l_return_status VARCHAR2(2000);
50: l_billing_type_category cs_billing_type_categories.billing_category%TYPE;
51:
52: --getting billing category using transaction type id
53: CURSOR l_txn_billing_csr(p_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE, p_user_id IN NUMBER)
54: IS
55: SELECT cbtc.billing_category
56: FROM csf_debrief_lines lines,
57: mtl_system_items_b msi,

Line 56: FROM csf_debrief_lines lines,

52: --getting billing category using transaction type id
53: CURSOR l_txn_billing_csr(p_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE, p_user_id IN NUMBER)
54: IS
55: SELECT cbtc.billing_category
56: FROM csf_debrief_lines lines,
57: mtl_system_items_b msi,
58: cs_txn_billing_types txbt,
59: CS_BILLING_TYPE_CATEGORIES cbtc
60: WHERE lines.debrief_line_id = p_debrief_line_id

Line 68: CURSOR l_txn_billing_type_csr(p_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE)

64: AND msi.material_billable_flag = txbt.billing_type
65: AND txbt.billing_type = cbtc.billing_type;
66:
67: --getting billing category using Billing type id
68: CURSOR l_txn_billing_type_csr(p_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE)
69: IS
70: SELECT cbtc.billing_category
71: FROM csf_debrief_lines lines,
72: cs_txn_billing_types txbt,

Line 71: FROM csf_debrief_lines lines,

67: --getting billing category using Billing type id
68: CURSOR l_txn_billing_type_csr(p_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE)
69: IS
70: SELECT cbtc.billing_category
71: FROM csf_debrief_lines lines,
72: cs_txn_billing_types txbt,
73: CS_BILLING_TYPE_CATEGORIES cbtc
74: WHERE lines.debrief_line_id = p_debrief_line_id
75: AND lines.txn_billing_type_id = txbt.txn_billing_type_id

Line 159: CURSOR l_csm_debrfLnInsInit_csr (p_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE)

155: l_user_id NUMBER;
156: l_material_billable_flag VARCHAR2(1);
157: l_labor_exp_organization_id NUMBER;
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: usage_type

Line 164: FROM csf_debrief_lines dbl,

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: usage_type
164: FROM csf_debrief_lines dbl,
165: csf_debrief_headers dhdr,
166: jtf_task_assignments jta,
167: jtf_rs_resource_extns jtrs
168: WHERE dbl.debrief_line_id = p_debrief_line_id

Line 260: CURSOR l_csm_debrfLnDel_csr (p_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE, p_user_id IN NUMBER)

256: l_return_status VARCHAR2(2000);
257: l_user_id NUMBER;
258: l_material_billable_flag VARCHAR2(1);
259:
260: CURSOR l_csm_debrfLnDel_csr (p_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE, p_user_id IN NUMBER)
261: IS
262: SELECT acc.user_id, dbl.inventory_item_id, dbl.instance_id,
263: NVL(NVL(dbl.issuing_inventory_org_id, dbl.receiving_inventory_org_id), csm_profile_pkg.get_organization_id(p_user_id)) AS organization_id,
264: usage_type

Line 265: FROM csf_debrief_lines dbl,

261: IS
262: SELECT acc.user_id, dbl.inventory_item_id, dbl.instance_id,
263: NVL(NVL(dbl.issuing_inventory_org_id, dbl.receiving_inventory_org_id), csm_profile_pkg.get_organization_id(p_user_id)) AS organization_id,
264: usage_type
265: FROM csf_debrief_lines dbl,
266: csm_debrief_lines_acc acc
267: WHERE dbl.debrief_line_id = p_debrief_line_id
268: AND acc.debrief_line_id = dbl.debrief_line_id
269: AND acc.user_id = p_user_id;

Line 372: CURSOR l_csm_debrfLnUpdInit_csr (p_debrief_line_id csf_debrief_lines.debrief_line_id%type) IS

368: l_error_msg VARCHAR2(4000);
369: l_return_status VARCHAR2(2000);
370: l_material_billable_flag VARCHAR2(1);
371:
372: CURSOR l_csm_debrfLnUpdInit_csr (p_debrief_line_id csf_debrief_lines.debrief_line_id%type) IS
373: SELECT dhdr.task_assignment_id,
374: jtrs.user_id,
375: jta.resource_id,
376: dbl.inventory_item_id,

Line 381: FROM csf_debrief_lines dbl,

377: dbl.instance_id,
378: NVL(nvl(issuing_inventory_org_id, receiving_inventory_org_id), csm_profile_pkg.get_organization_id(jtrs.user_id)) AS organization_id,
379: acc.access_id,
380: usage_type
381: FROM csf_debrief_lines dbl,
382: csf_debrief_headers dhdr,
383: csm_debrief_lines_acc acc,
384: jtf_task_assignments jta,
385: jtf_rs_resource_extns jtrs