[Home] [Help]
10: p_resource_id in number,
11: p_uom_code in varchar2,
12: p_basis_type in number,
13: p_activity_id in number,
14: p_standard_rate_flag in number,
15: p_start_date in date,
16: p_completion_date in date) is
17: x_user_id number;
18: x_login_id number;
36: resource_id,
37: uom_code,
38: basis_type,
39: activity_id,
40: standard_rate_flag,
41: usage_rate_or_amount,
42: scheduled_flag,
43: assigned_units,
44: autocharge_type,
60: p_resource_id,
61: p_uom_code,
62: nvl(p_basis_type, WIP_CONSTANTS.PER_LOT),
63: p_activity_id,
64: p_standard_rate_flag,
65: 0, -- usage_rate_or_amount
66: WIP_CONSTANTS.NO, -- scheduled_flag
67: 1, -- assigned_units
68: WIP_CONSTANTS.MANUAL, -- autocharge_type
176: resource_id,
177: uom_code,
178: basis_type,
179: activity_id,
180: standard_rate_flag,
181: usage_rate_or_amount,
182: scheduled_flag,
183: assigned_units,
184: autocharge_type,
200: wcti.resource_id,
201: wcti.primary_uom,
202: nvl(wcti.basis_type, WIP_CONSTANTS.PER_LOT),
203: br.default_activity_id,
204: wcti.standard_rate_flag,
205: 0, -- usage_rate_or_amount
206: WIP_CONSTANTS.NO, -- scheduled_flag
207: 1, -- assigned_units
208: WIP_CONSTANTS.MANUAL, -- autocharge_type
390: X_Activity_Id NUMBER,
391: X_Scheduled_Flag NUMBER,
392: X_Assigned_Units NUMBER,
393: X_Autocharge_Type NUMBER,
394: X_Standard_Rate_Flag NUMBER,
395: X_Applied_Resource_Units NUMBER,
396: X_Applied_Resource_Value NUMBER,
397: X_Attribute_Category VARCHAR2,
398: X_Attribute1 VARCHAR2,
446: activity_id,
447: scheduled_flag,
448: assigned_units,
449: autocharge_type,
450: standard_rate_flag,
451: applied_resource_units,
452: applied_resource_value,
453: attribute_category,
454: attribute1,
490: X_Activity_Id,
491: X_Scheduled_Flag,
492: X_Assigned_Units,
493: X_Autocharge_Type,
494: X_Standard_Rate_Flag,
495: X_Applied_Resource_Units,
496: X_Applied_Resource_Value,
497: X_Attribute_Category,
498: X_Attribute1,
542: X_Activity_Id NUMBER,
543: X_Scheduled_Flag NUMBER,
544: X_Assigned_Units NUMBER,
545: X_Autocharge_Type NUMBER,
546: X_Standard_Rate_Flag NUMBER,
547: X_Applied_Resource_Units NUMBER,
548: X_Applied_Resource_Value NUMBER,
549: X_Attribute_Category VARCHAR2,
550: X_Attribute1 VARCHAR2,
607: AND ( (Recinfo.assigned_units = X_Assigned_Units)
608: OR ( (Recinfo.assigned_units IS NULL)
609: AND (X_Assigned_Units IS NULL)))
610: AND (Recinfo.autocharge_type = X_Autocharge_Type)
611: AND (Recinfo.standard_rate_flag = X_Standard_Rate_Flag)
612: AND (Recinfo.applied_resource_units = X_Applied_Resource_Units)
613: AND (Recinfo.applied_resource_value = X_Applied_Resource_Value)
614: AND ( (Recinfo.attribute_category = X_Attribute_Category)
615: OR ( (Recinfo.attribute_category IS NULL)
692: X_Activity_Id NUMBER,
693: X_Scheduled_Flag NUMBER,
694: X_Assigned_Units NUMBER,
695: X_Autocharge_Type NUMBER,
696: X_Standard_Rate_Flag NUMBER,
697: X_Applied_Resource_Units NUMBER,
698: X_Applied_Resource_Value NUMBER,
699: X_Attribute_Category VARCHAR2,
700: X_Attribute1 VARCHAR2,
737: activity_id = X_Activity_Id,
738: scheduled_flag = X_Scheduled_Flag,
739: assigned_units = X_Assigned_Units,
740: autocharge_type = X_Autocharge_Type,
741: standard_rate_flag = X_Standard_Rate_Flag,
742: applied_resource_units = X_Applied_Resource_Units,
743: applied_resource_value = X_Applied_Resource_Value,
744: attribute_category = X_Attribute_Category,
745: attribute1 = X_Attribute1,
919: scheduled_flag,
920: assigned_units,
921: maximum_assigned_units,
922: autocharge_type,
923: standard_rate_flag,
924: applied_resource_units,
925: applied_resource_value,
926: attribute_category,
927: attribute1,
964: scheduled_flag,
965: assigned_units,
966: maximum_assigned_units,
967: autocharge_type,
968: standard_rate_flag,
969: applied_resource_units,
970: applied_resource_value,
971: attribute_category,
972: attribute1,
1064: scheduled_flag,
1065: assigned_units,
1066: maximum_assigned_units,
1067: autocharge_type,
1068: standard_rate_flag,
1069: applied_resource_units,
1070: applied_resource_value,
1071: attribute_category,
1072: attribute1,
1110: scheduled_flag,
1111: assigned_units,
1112: maximum_assigned_units,
1113: autocharge_type,
1114: standard_rate_flag,
1115: applied_resource_units,
1116: applied_resource_value,
1117: attribute_category,
1118: attribute1,