DBA Data[Home] [Help]

APPS.WIP_WS_TIME_ENTRY dependencies on WIP_CONSTANTS

Line 8: G_RES_CHG_FAILED Number :=wip_constants.no;

4: G_WIP_WS_PREF_CHARGE_RESOURCE CONSTANT NUMBER := 5;
5: G_WIP_WS_PREF_TIME_ENTRY_MODE CONSTANT NUMBER := 26;
6: G_BOM_AUTOCHARGE_TYPE_MANUAL CONSTANT NUMBER := 2;
7:
8: G_RES_CHG_FAILED Number :=wip_constants.no;
9:
10: -- Insert a record into the wip_resource_actual_times table.
11: PROCEDURE record_insert(
12: p_time_entry_id in number,

Line 246: WIP_CONSTANTS.RES_VAL,

242: fnd_global.login_id,
243: p_operation_seq_num,
244: l_organization_code,
245: p_organization_id,
246: WIP_CONSTANTS.RES_VAL,
247: WIP_CONSTANTS.PENDING,
248: p_resource_id,
249: l_resource_code,
250: p_resource_seq_num,

Line 247: WIP_CONSTANTS.PENDING,

243: p_operation_seq_num,
244: l_organization_code,
245: p_organization_id,
246: WIP_CONSTANTS.RES_VAL,
247: WIP_CONSTANTS.PENDING,
248: p_resource_id,
249: l_resource_code,
250: p_resource_seq_num,
251: WIP_CONSTANTS.SOURCE_CODE,

Line 251: WIP_CONSTANTS.SOURCE_CODE,

247: WIP_CONSTANTS.PENDING,
248: p_resource_id,
249: l_resource_code,
250: p_resource_seq_num,
251: WIP_CONSTANTS.SOURCE_CODE,
252: sysdate,
253: p_duration, --non time based resource implies no start/end time which means duration is mandatory
254: WIP_CONSTANTS.RES_TXN,
255: p_uom_code,

Line 254: WIP_CONSTANTS.RES_TXN,

250: p_resource_seq_num,
251: WIP_CONSTANTS.SOURCE_CODE,
252: sysdate,
253: p_duration, --non time based resource implies no start/end time which means duration is mandatory
254: WIP_CONSTANTS.RES_TXN,
255: p_uom_code,
256: WIP_CONSTANTS.DISCRETE,
257: p_wip_entity_id,
258: l_wip_entity_name,

Line 256: WIP_CONSTANTS.DISCRETE,

252: sysdate,
253: p_duration, --non time based resource implies no start/end time which means duration is mandatory
254: WIP_CONSTANTS.RES_TXN,
255: p_uom_code,
256: WIP_CONSTANTS.DISCRETE,
257: p_wip_entity_id,
258: l_wip_entity_name,
259: l_employee_id,
260: l_employee_num);

Line 1173: G_RES_CHG_FAILED := wip_constants.yes;

1169: and wrat.employee_id = mec.employee_id
1170: and wrat.organization_id = mec.organization_id;
1171: exception
1172: when no_data_found then
1173: G_RES_CHG_FAILED := wip_constants.yes;
1174: end;
1175: else
1176: l_employee_id := null;
1177: l_employee_num := null;

Line 1180: if G_RES_CHG_FAILED <> wip_constants.yes then

1176: l_employee_id := null;
1177: l_employee_num := null;
1178: end if;
1179:
1180: if G_RES_CHG_FAILED <> wip_constants.yes then
1181:
1182: insert into wip_cost_txn_interface(
1183: created_by,
1184: created_by_name,

Line 1219: WIP_CONSTANTS.RES_VAL,

1215: fnd_global.login_id,
1216: p_completed_op,
1217: l_organization_code,
1218: l_org_id,
1219: WIP_CONSTANTS.RES_VAL,
1220: WIP_CONSTANTS.PENDING,
1221: l_resource_id,
1222: l_resource_code,
1223: l_resource_seq_num,

Line 1220: WIP_CONSTANTS.PENDING,

1216: p_completed_op,
1217: l_organization_code,
1218: l_org_id,
1219: WIP_CONSTANTS.RES_VAL,
1220: WIP_CONSTANTS.PENDING,
1221: l_resource_id,
1222: l_resource_code,
1223: l_resource_seq_num,
1224: WIP_CONSTANTS.SOURCE_CODE,

Line 1224: WIP_CONSTANTS.SOURCE_CODE,

1220: WIP_CONSTANTS.PENDING,
1221: l_resource_id,
1222: l_resource_code,
1223: l_resource_seq_num,
1224: WIP_CONSTANTS.SOURCE_CODE,
1225: sysdate,
1226: l_duration,
1227: WIP_CONSTANTS.RES_TXN,
1228: l_uom_code,

Line 1227: WIP_CONSTANTS.RES_TXN,

1223: l_resource_seq_num,
1224: WIP_CONSTANTS.SOURCE_CODE,
1225: sysdate,
1226: l_duration,
1227: WIP_CONSTANTS.RES_TXN,
1228: l_uom_code,
1229: WIP_CONSTANTS.DISCRETE,
1230: p_wip_entity_id,
1231: l_wip_entity_name,

Line 1229: WIP_CONSTANTS.DISCRETE,

1225: sysdate,
1226: l_duration,
1227: WIP_CONSTANTS.RES_TXN,
1228: l_uom_code,
1229: WIP_CONSTANTS.DISCRETE,
1230: p_wip_entity_id,
1231: l_wip_entity_name,
1232: l_employee_id,
1233: l_employee_num);

Line 2446: if G_RES_CHG_FAILED =wip_constants.yes then

2442: l_clock_status := 'S';
2443: end if;
2444: close clock_out_test_cursor;
2445: /* Added for bug 6891758.*/
2446: if G_RES_CHG_FAILED =wip_constants.yes then
2447: l_clock_status := 'T';
2448: end if;
2449: x_status := l_clock_status;
2450: END clock_out;