[Home] [Help]
47: g_ledger_name VARCHAR2(250);
48: g_process_category VARCHAR2(250);
49:
50: g_cost_type_id NUMBER; /* New cost type terminology */
51: g_cost_type_code VARCHAR2(40); /* cm_mthd_mst.cost_mthd_code */
52: g_cost_method_type NUMBER; /* cm_mthd_mst.cost_type */
53: g_cost_method VARCHAR2(100); /* lkup 'GMF_COST_METHOD' meaning */
54: g_default_cost_type_id NUMBER;
55:
48: g_process_category VARCHAR2(250);
49:
50: g_cost_type_id NUMBER; /* New cost type terminology */
51: g_cost_type_code VARCHAR2(40); /* cm_mthd_mst.cost_mthd_code */
52: g_cost_method_type NUMBER; /* cm_mthd_mst.cost_type */
53: g_cost_method VARCHAR2(100); /* lkup 'GMF_COST_METHOD' meaning */
54: g_default_cost_type_id NUMBER;
55:
56: g_crev_curr_cost_type_id NUMBER;
207: /* Start INVCONV umoogala
208: CURSOR c_fiscal_policy(cp_co_code VARCHAR2)
209: IS
210: SELECT NVL(mthd.lot_actual_cost,0)
211: FROM gl_plcy_mst plcy, cm_mthd_mst mthd
212: WHERE plcy.co_code = cp_co_code
213: ;
214: */
215: l_procedure_name CONSTANT VARCHAR2(30) := 'UPDATE_PROCESS';
424: INTO g_legal_entity_name, g_ledger_name,
425: g_cost_method_type, g_cost_type_code, g_cost_method,
426: g_default_cost_type_id
427: FROM org_organization_definitions le, gl_ledgers led,
428: cm_mthd_mst mthd, gem_lookups lk
429: WHERE le.organization_id = g_legal_entity_id
430: AND led.ledger_id = g_ledger_id
431: AND mthd.cost_type_id = g_cost_type_id
432: AND lk.lookup_type = 'GMF_COST_METHOD'
466: INTO g_cost_method_type,
467: g_cost_type_code,
468: g_cost_method,
469: g_default_cost_type_id
470: FROM cm_mthd_mst mthd,
471: gem_lookups lk
472: WHERE mthd.cost_type_id = g_cost_type_id
473: AND lk.lookup_type = 'GMF_COST_METHOD'
474: AND lk.lookup_code = mthd.cost_type ;
527: SELECT curr.period_id, prev.period_id,
528: mthd.cost_mthd_code
529: INTO g_crev_curr_period_id, g_crev_prev_period_id,
530: g_crev_prev_cost_mthd
531: FROM gmf_period_statuses curr, gmf_period_statuses prev, cm_mthd_mst mthd
532: WHERE curr.legal_entity_id = g_legal_entity_id
533: AND curr.cost_type_id = g_cost_type_id
534: AND curr.calendar_code = g_crev_curr_calendar
535: AND curr.period_code = g_crev_curr_period
1870: g_cost_type_code, /* cost_mthd_code */
1871: g_cost_method_type, /* cost_type */
1872: g_default_cost_type_id,
1873: DECODE(g_default_cost_type_id, NULL, NULL, /* default_lot_cost_mthd */
1874: (SELECT default_lot_cost_mthd from cm_mthd_mst
1875: WHERE cost_type_id = g_default_cost_type_id
1876: AND delete_mark = 0)),
1877: plcy.cost_basis,
1878: 0, /* extract_hdr_rows_posted, */
2519: INTO g_legal_entity_name, g_ledger_name,
2520: g_cost_method_type, g_cost_type_code, g_cost_method,
2521: g_default_cost_type_id
2522: FROM org_organization_definitions le, gl_ledgers led,
2523: cm_mthd_mst mthd, gem_lookups lk
2524: WHERE le.organization_id = g_legal_entity_id
2525: AND led.ledger_id = g_ledger_id
2526: AND mthd.cost_type_id = g_cost_type_id
2527: AND lk.lookup_type = 'GMF_COST_METHOD'
2561: INTO g_cost_method_type,
2562: g_cost_type_code,
2563: g_cost_method,
2564: g_default_cost_type_id
2565: FROM cm_mthd_mst mthd,
2566: gem_lookups lk
2567: WHERE mthd.cost_type_id = g_cost_type_id
2568: AND lk.lookup_type = 'GMF_COST_METHOD'
2569: AND lk.lookup_code = mthd.cost_type ;
2612: SELECT curr.period_id, prev.period_id,
2613: mthd.cost_mthd_code
2614: INTO g_crev_curr_period_id, g_crev_prev_period_id,
2615: g_crev_prev_cost_mthd
2616: FROM gmf_period_statuses curr, gmf_period_statuses prev, cm_mthd_mst mthd
2617: WHERE curr.legal_entity_id = g_legal_entity_id
2618: AND curr.cost_type_id = g_cost_type_id
2619: AND curr.calendar_code = g_crev_curr_calendar
2620: AND curr.period_code = g_crev_curr_period