APPS.FND_OAM_DSCRAM_ARGS_PKG dependencies on FND_OAM_DSCRAM_ARG_VALUES

Line 901: INSERT INTO FND_OAM_DSCRAM_ARG_VALUES (ARG_VALUE_ID,

897: x_arg_val_id OUT NOCOPY NUMBER)
898: IS
899: l_id NUMBER;
900: BEGIN
901: INSERT INTO FND_OAM_DSCRAM_ARG_VALUES (ARG_VALUE_ID,
902: ARG_ID,
903: PARENT_TYPE,
904: PARENT_ID,
905: ROWID_LBOUND,

Line 917: (fnd_oam_dscram_arg_values_s.nextval,

913: LAST_UPDATED_BY,
914: LAST_UPDATE_DATE,
915: LAST_UPDATE_LOGIN)
916: VALUES
917: (fnd_oam_dscram_arg_values_s.nextval,
918: p_arg_id,
919: p_parent_type,
920: p_parent_id,
921: p_rowid_lbound,

Line 964: UPDATE fnd_oam_dscram_arg_values

960: last_update_date = SYSDATE
961: WHERE arg_id = px_arg.arg_id;
962: ELSIF px_arg.write_policy = FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_WORKER THEN
963: --try to update arg_values with parent_type=worker, failing that insert
964: UPDATE fnd_oam_dscram_arg_values
965: SET valid_value_flag = px_arg.valid_value_flag,
966: canonical_value = px_arg.canonical_value,
967: last_updated_by = fnd_global.user_id,
968: last_update_login = fnd_global.user_id,

Line 984: UPDATE fnd_oam_dscram_arg_values

980: x_arg_val_id => l_arg_val_id);
981: END IF;
982: ELSIF px_arg.write_policy = FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE THEN
983: --update arg_values with range values and parent_type = range
984: UPDATE fnd_oam_dscram_arg_values
985: SET valid_value_flag = px_arg.valid_value_flag,
986: canonical_value = px_arg.canonical_value,
987: rowid_lbound = px_arg.rowid_lbound,
988: rowid_ubound = px_arg.rowid_ubound,

Line 1177: FROM fnd_oam_dscram_arg_values

1173: --query arg_values with parent_type=worker
1174: BEGIN
1175: SELECT valid_value_flag, canonical_value
1176: INTO l_valid_value_flag, l_canonical_value
1177: FROM fnd_oam_dscram_arg_values
1178: WHERE arg_id = px_arg.arg_id AND
1179: parent_type = FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_WORKER AND
1180: parent_id = FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKER_ID;
1181: EXCEPTION

Line 1193: FROM fnd_oam_dscram_arg_values

1189: --query arg_values with range values and parent_type = range
1190: BEGIN
1191: SELECT valid_value_flag, canonical_value
1192: INTO l_valid_value_flag, l_canonical_value
1193: FROM fnd_oam_dscram_arg_values
1194: WHERE arg_id = px_arg.arg_id AND
1195: parent_type = FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_RANGE AND
1196: rowid_lbound = p_rowid_lbound AND
1197: rowid_ubound = p_rowid_ubound;