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: x_state_num number := 0;
23: l_scheduled_flag number := 2;

Line 52: autocharge_type, standard_rate_flag

48: end if;
49: begin
50: /* Derive resource information */
51: SELECT unit_of_measure, default_basis_type, default_activity_id,
52: autocharge_type, standard_rate_flag
53: INTO x_uom_code, x_basis_type, x_activity_id,
54: x_autocharge_type, x_standard_rate_flag
55: FROM BOM_RESOURCES
56: WHERE resource_id = p_resource_id_new;

Line 54: x_autocharge_type, x_standard_rate_flag

50: /* Derive resource information */
51: SELECT unit_of_measure, default_basis_type, default_activity_id,
52: autocharge_type, standard_rate_flag
53: INTO x_uom_code, x_basis_type, x_activity_id,
54: x_autocharge_type, x_standard_rate_flag
55: FROM BOM_RESOURCES
56: WHERE resource_id = p_resource_id_new;
57:
58: x_state_num := x_state_num + 1;

Line 74: if (x_standard_rate_flag IS NULL) then

70: if (x_basis_type IS NULL) then
71: x_basis_type := 1; /* item, from form */
72: End if;
73:
74: if (x_standard_rate_flag IS NULL) then
75: x_standard_rate_flag := 1; /* yes */
76: End If;
77:
78: /*Bug 13829499: Add select...into to get the values of SF and AU from WOR. If the operation is being newly added

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

71: x_basis_type := 1; /* item, from form */
72: End if;
73:
74: if (x_standard_rate_flag IS NULL) then
75: x_standard_rate_flag := 1; /* yes */
76: End If;
77:
78: /*Bug 13829499: Add select...into to get the values of SF and AU from WOR. If the operation is being newly added
79: then no data will be found and hence the default values of (No and 1) will be defaulted*/

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

108: WIP_JOB_DETAILS.WIP_ADD,
109: nvl(activity_id,x_activity_id),
110: activity_id), /*Bug 2683271*/
111: autocharge_type = nvl(autocharge_type,x_autocharge_type), /*Fix for bug 6767640*/
112: standard_rate_flag = nvl(standard_rate_flag,x_standard_rate_flag), /*Fix for bug 6767640*/
113: start_date = nvl(start_date,x_start_date),
114: completion_date = nvl(completion_date,x_completion_date)
115: WHERE group_id = p_group_id
116: AND wip_entity_id = p_wip_entity_id