DBA Data[Home] [Help]

APPS.WIP_RESOURCE_DEFAULT dependencies on STANDARD

Line 19: x_standard_rate_flag number;

15: x_uom_code varchar2(3);
16: x_basis_type number;
17: x_activity_id number;
18: x_autocharge_type number;
19: x_standard_rate_flag number;
20: x_start_date date;
21: x_completion_date date;
22:
23: x_state_num number := 0;

Line 30: autocharge_type, standard_rate_flag

26:
27: begin
28: /* Derive resource information */
29: SELECT unit_of_measure, default_basis_type, default_activity_id,
30: autocharge_type, standard_rate_flag
31: INTO x_uom_code, x_basis_type, x_activity_id,
32: x_autocharge_type, x_standard_rate_flag
33: FROM BOM_RESOURCES
34: WHERE resource_id = p_resource_id_new;

Line 32: x_autocharge_type, x_standard_rate_flag

28: /* Derive resource information */
29: SELECT unit_of_measure, default_basis_type, default_activity_id,
30: autocharge_type, standard_rate_flag
31: INTO x_uom_code, x_basis_type, x_activity_id,
32: x_autocharge_type, x_standard_rate_flag
33: FROM BOM_RESOURCES
34: WHERE resource_id = p_resource_id_new;
35:
36: x_state_num := x_state_num + 1;

Line 52: if (x_standard_rate_flag IS NULL) then

48: if (x_basis_type IS NULL) then
49: x_basis_type := 1; /* item, from form */
50: End if;
51:
52: if (x_standard_rate_flag IS NULL) then
53: x_standard_rate_flag := 1; /* yes */
54: End If;
55:
56:

Line 53: x_standard_rate_flag := 1; /* yes */

49: x_basis_type := 1; /* item, from form */
50: End if;
51:
52: if (x_standard_rate_flag IS NULL) then
53: x_standard_rate_flag := 1; /* yes */
54: End If;
55:
56:
57: UPDATE WIP_JOB_DTLS_INTERFACE

Line 73: standard_rate_flag = nvl(standard_rate_flag,x_standard_rate_flag), /*Fix for bug 6767640*/

69: WIP_JOB_DETAILS.WIP_ADD,
70: nvl(activity_id,x_activity_id),
71: activity_id), /*Bug 2683271*/
72: autocharge_type = nvl(autocharge_type,x_autocharge_type), /*Fix for bug 6767640*/
73: standard_rate_flag = nvl(standard_rate_flag,x_standard_rate_flag), /*Fix for bug 6767640*/
74: start_date = nvl(start_date,x_start_date),
75: completion_date = nvl(completion_date,x_completion_date)
76: WHERE group_id = p_group_id
77: AND wip_entity_id = p_wip_entity_id