DBA Data[Home] [Help]

APPS.MSC_RP_PUB dependencies on FND_PROFILE

Line 1124: values(p_plan_id, 'COMP_SUBSTITUTION_OPTION' , fnd_profile.value('COMP_SUBSTITUTION_OPTION'), sysdate,

1120:
1121:
1122: insert into msc_plan_profiles (plan_id,
1123: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)
1124: values(p_plan_id, 'COMP_SUBSTITUTION_OPTION' , fnd_profile.value('COMP_SUBSTITUTION_OPTION'), sysdate,
1125: p_user_id, sysdate, p_user_id,p_user_id);
1126:
1127: insert into msc_plan_profiles (plan_id,
1128: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)

Line 1129: values(p_plan_id, 'LATENESS_THRESHOLD' , fnd_profile.value('LATENESS_THRESHOLD'), sysdate, p_user_id,

1125: p_user_id, sysdate, p_user_id,p_user_id);
1126:
1127: insert into msc_plan_profiles (plan_id,
1128: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)
1129: values(p_plan_id, 'LATENESS_THRESHOLD' , fnd_profile.value('LATENESS_THRESHOLD'), sysdate, p_user_id,
1130: sysdate, p_user_id,p_user_id);
1131:
1132: insert into msc_plan_profiles (plan_id,
1133: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)

Line 1135: fnd_profile.value('MRP_FIRM_OE_XFERRED_INTERNAL_REQ'), sysdate, p_user_id, sysdate, p_user_id,p_user_id);

1131:
1132: insert into msc_plan_profiles (plan_id,
1133: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)
1134: values(p_plan_id, 'MRP_FIRM_OE_XFERRED_INTERNAL_REQ' ,
1135: fnd_profile.value('MRP_FIRM_OE_XFERRED_INTERNAL_REQ'), sysdate, p_user_id, sysdate, p_user_id,p_user_id);
1136:
1137: insert into msc_plan_profiles (plan_id,
1138: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)
1139: values(p_plan_id, 'MRP_FIRM_ORDER_TF' , fnd_profile.value('MRP_FIRM_ORDER_TF'), sysdate, p_user_id,

Line 1139: values(p_plan_id, 'MRP_FIRM_ORDER_TF' , fnd_profile.value('MRP_FIRM_ORDER_TF'), sysdate, p_user_id,

1135: fnd_profile.value('MRP_FIRM_OE_XFERRED_INTERNAL_REQ'), sysdate, p_user_id, sysdate, p_user_id,p_user_id);
1136:
1137: insert into msc_plan_profiles (plan_id,
1138: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)
1139: values(p_plan_id, 'MRP_FIRM_ORDER_TF' , fnd_profile.value('MRP_FIRM_ORDER_TF'), sysdate, p_user_id,
1140: sysdate, p_user_id,p_user_id);
1141:
1142: insert into msc_plan_profiles (plan_id,
1143: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)

Line 1144: values(p_plan_id, 'MRP_FIRM_PO_TF' , fnd_profile.value('MRP_FIRM_PO_TF'), sysdate, p_user_id, sysdate,

1140: sysdate, p_user_id,p_user_id);
1141:
1142: insert into msc_plan_profiles (plan_id,
1143: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)
1144: values(p_plan_id, 'MRP_FIRM_PO_TF' , fnd_profile.value('MRP_FIRM_PO_TF'), sysdate, p_user_id, sysdate,
1145: p_user_id,p_user_id);
1146:
1147: insert into msc_plan_profiles (plan_id,
1148: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)

Line 1149: values(p_plan_id, 'MRP_LOAD_REQ_GROUP_BY' , fnd_profile.value('MRP_LOAD_REQ_GROUP_BY'), sysdate, p_user_id,

1145: p_user_id,p_user_id);
1146:
1147: insert into msc_plan_profiles (plan_id,
1148: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)
1149: values(p_plan_id, 'MRP_LOAD_REQ_GROUP_BY' , fnd_profile.value('MRP_LOAD_REQ_GROUP_BY'), sysdate, p_user_id,
1150: sysdate, p_user_id,p_user_id);
1151:
1152: insert into msc_plan_profiles (plan_id,
1153: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)

Line 1154: values(p_plan_id, 'MSC_AUTO_REL_COMP_TOLERANCE' , fnd_profile.value('MSC_AUTO_REL_COMP_TOLERANCE'),

1150: sysdate, p_user_id,p_user_id);
1151:
1152: insert into msc_plan_profiles (plan_id,
1153: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)
1154: values(p_plan_id, 'MSC_AUTO_REL_COMP_TOLERANCE' , fnd_profile.value('MSC_AUTO_REL_COMP_TOLERANCE'),
1155: sysdate, p_user_id, sysdate, p_user_id,p_user_id);
1156:
1157: insert into msc_plan_profiles (plan_id,
1158: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)

Line 1159: values(p_plan_id, 'MSC_CONSUME_FORECAST_DTF' , fnd_profile.value('MSC_CONSUME_FORECAST_DTF'), sysdate,

1155: sysdate, p_user_id, sysdate, p_user_id,p_user_id);
1156:
1157: insert into msc_plan_profiles (plan_id,
1158: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)
1159: values(p_plan_id, 'MSC_CONSUME_FORECAST_DTF' , fnd_profile.value('MSC_CONSUME_FORECAST_DTF'), sysdate,
1160: p_user_id, sysdate, p_user_id,p_user_id);
1161:
1162: insert into msc_plan_profiles (plan_id,
1163: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)

Line 1164: values(p_plan_id, 'MSC_CONSUME_INT_SALES_ORDERS' , fnd_profile.value('MSC_CONSUME_INT_SALES_ORDERS'),

1160: p_user_id, sysdate, p_user_id,p_user_id);
1161:
1162: insert into msc_plan_profiles (plan_id,
1163: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)
1164: values(p_plan_id, 'MSC_CONSUME_INT_SALES_ORDERS' , fnd_profile.value('MSC_CONSUME_INT_SALES_ORDERS'),
1165: sysdate, p_user_id, sysdate, p_user_id,p_user_id);
1166:
1167: insert into msc_plan_profiles (plan_id,
1168: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)

Line 1169: values(p_plan_id, 'MSC_CONSUME_NULL_DC' , fnd_profile.value('MSC_CONSUME_NULL_DC'), sysdate, p_user_id,

1165: sysdate, p_user_id, sysdate, p_user_id,p_user_id);
1166:
1167: insert into msc_plan_profiles (plan_id,
1168: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)
1169: values(p_plan_id, 'MSC_CONSUME_NULL_DC' , fnd_profile.value('MSC_CONSUME_NULL_DC'), sysdate, p_user_id,
1170: sysdate, p_user_id,p_user_id);
1171:
1172: insert into msc_plan_profiles (plan_id,
1173: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)

Line 1174: values(p_plan_id, 'MSC_FIRM_PURCH_REQ_TF' , fnd_profile.value('MSC_FIRM_PURCH_REQ_TF'), sysdate, p_user_id,

1170: sysdate, p_user_id,p_user_id);
1171:
1172: insert into msc_plan_profiles (plan_id,
1173: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)
1174: values(p_plan_id, 'MSC_FIRM_PURCH_REQ_TF' , fnd_profile.value('MSC_FIRM_PURCH_REQ_TF'), sysdate, p_user_id,
1175: sysdate, p_user_id,p_user_id);
1176:
1177: insert into msc_plan_profiles (plan_id,
1178: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)

Line 1179: values(p_plan_id, 'MSC_INFLATE_WIP' , fnd_profile.value('MSC_INFLATE_WIP'), sysdate, p_user_id, sysdate,

1175: sysdate, p_user_id,p_user_id);
1176:
1177: insert into msc_plan_profiles (plan_id,
1178: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)
1179: values(p_plan_id, 'MSC_INFLATE_WIP' , fnd_profile.value('MSC_INFLATE_WIP'), sysdate, p_user_id, sysdate,
1180: p_user_id,p_user_id);
1181:
1182: insert into msc_plan_profiles (plan_id,
1183: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)

Line 1184: values(p_plan_id, 'MSC_RELEASED_BY_USER_ONLY' , fnd_profile.value('MSC_RELEASED_BY_USER_ONLY'), sysdate,

1180: p_user_id,p_user_id);
1181:
1182: insert into msc_plan_profiles (plan_id,
1183: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)
1184: values(p_plan_id, 'MSC_RELEASED_BY_USER_ONLY' , fnd_profile.value('MSC_RELEASED_BY_USER_ONLY'), sysdate,
1185: p_user_id, sysdate, p_user_id,p_user_id);
1186:
1187: -- Bug 16898396 - In ASCP-RP COPY , set MSC_RELEASE_FLAG default value to Y
1188: insert into msc_plan_profiles (plan_id,

Line 1195: values(p_plan_id, 'MSC_RP_GROUP_PLANNED_ORDERS' , fnd_profile.value('MSC_RP_GROUP_PLANNED_ORDERS'),

1191: p_user_id,p_user_id);
1192:
1193: insert into msc_plan_profiles (plan_id,
1194: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)
1195: values(p_plan_id, 'MSC_RP_GROUP_PLANNED_ORDERS' , fnd_profile.value('MSC_RP_GROUP_PLANNED_ORDERS'),
1196: sysdate, p_user_id, sysdate, p_user_id,p_user_id);
1197:
1198: insert into msc_plan_profiles (plan_id,
1199: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)

Line 1205: values(p_plan_id, 'MSC_SS_BKT_START_OFFSET_DAYS' , fnd_profile.value('MSC_SS_BKT_START_OFFSET_DAYS'),

1201: sysdate, p_user_id, sysdate, p_user_id,p_user_id);
1202:
1203: insert into msc_plan_profiles (plan_id,
1204: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)
1205: values(p_plan_id, 'MSC_SS_BKT_START_OFFSET_DAYS' , fnd_profile.value('MSC_SS_BKT_START_OFFSET_DAYS'),
1206: sysdate, p_user_id, sysdate, p_user_id,p_user_id);
1207:
1208: insert into msc_plan_profiles (plan_id,
1209: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)

Line 1210: values(p_plan_id, 'MSO_DEFAULT_FORECAST_PRIORITY' , fnd_profile.value('MSO_DEFAULT_FORECAST_PRIORITY'),

1206: sysdate, p_user_id, sysdate, p_user_id,p_user_id);
1207:
1208: insert into msc_plan_profiles (plan_id,
1209: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)
1210: values(p_plan_id, 'MSO_DEFAULT_FORECAST_PRIORITY' , fnd_profile.value('MSO_DEFAULT_FORECAST_PRIORITY'),
1211: sysdate, p_user_id, sysdate, p_user_id,p_user_id);
1212:
1213: insert into msc_plan_profiles (plan_id,
1214: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)

Line 1215: values(p_plan_id, 'MSO_DEFAULT_SO_PRIORITY' , fnd_profile.value('MSO_DEFAULT_SO_PRIORITY'), sysdate,

1211: sysdate, p_user_id, sysdate, p_user_id,p_user_id);
1212:
1213: insert into msc_plan_profiles (plan_id,
1214: profile_code,profile_value,last_update_date,last_updated_by,creation_date,created_by,last_update_login)
1215: values(p_plan_id, 'MSO_DEFAULT_SO_PRIORITY' , fnd_profile.value('MSO_DEFAULT_SO_PRIORITY'), sysdate,
1216: p_user_id, sysdate, p_user_id,p_user_id);
1217:
1218: exception when others then
1219: rp_debug('Some exception in plan profile logic');