DBA Data[Home] [Help]

APPS.FND_OAM_DSCRAM_ARGS_PKG dependencies on FND_GLOBAL

Line 830: last_updated_by = fnd_global.user_id,

826: IF px_arg.initialized_success_flag IS NOT NULL THEN
827: UPDATE fnd_oam_dscram_args_b
828: SET initialized_success_flag = px_arg.initialized_success_flag,
829: source_final_text = l_source_final_text,
830: last_updated_by = fnd_global.user_id,
831: last_update_login = fnd_global.user_id,
832: last_update_date = SYSDATE
833: WHERE arg_id = px_arg.arg_id;
834:

Line 831: last_update_login = fnd_global.user_id,

827: UPDATE fnd_oam_dscram_args_b
828: SET initialized_success_flag = px_arg.initialized_success_flag,
829: source_final_text = l_source_final_text,
830: last_updated_by = fnd_global.user_id,
831: last_update_login = fnd_global.user_id,
832: last_update_date = SYSDATE
833: WHERE arg_id = px_arg.arg_id;
834:
835: --if the arg is writable and we determined if it has a valid value or not, write out the canonical value and valid_value_flag

Line 863: last_updated_by = fnd_global.user_id,

859: --x_return_* already set, only raised after locking select
860: BEGIN
861: UPDATE fnd_oam_dscram_args_b
862: SET initialized_success_flag = FND_API.G_FALSE,
863: last_updated_by = fnd_global.user_id,
864: last_update_login = fnd_global.user_id,
865: last_update_date = SYSDATE
866: WHERE arg_id = px_arg.arg_id;
867: COMMIT;

Line 864: last_update_login = fnd_global.user_id,

860: BEGIN
861: UPDATE fnd_oam_dscram_args_b
862: SET initialized_success_flag = FND_API.G_FALSE,
863: last_updated_by = fnd_global.user_id,
864: last_update_login = fnd_global.user_id,
865: last_update_date = SYSDATE
866: WHERE arg_id = px_arg.arg_id;
867: COMMIT;
868: px_arg.initialized_success_flag := FND_API.G_FALSE;

Line 927: FND_GLOBAL.USER_ID,

923: p_id_lbound,
924: p_id_ubound,
925: p_valid_value_flag,
926: p_canonical_value,
927: FND_GLOBAL.USER_ID,
928: SYSDATE,
929: FND_GLOBAL.USER_ID,
930: SYSDATE,
931: FND_GLOBAL.USER_ID)

Line 929: FND_GLOBAL.USER_ID,

925: p_valid_value_flag,
926: p_canonical_value,
927: FND_GLOBAL.USER_ID,
928: SYSDATE,
929: FND_GLOBAL.USER_ID,
930: SYSDATE,
931: FND_GLOBAL.USER_ID)
932: RETURNING ARG_VALUE_ID INTO l_id;
933: x_arg_val_id := l_id;

Line 931: FND_GLOBAL.USER_ID)

927: FND_GLOBAL.USER_ID,
928: SYSDATE,
929: FND_GLOBAL.USER_ID,
930: SYSDATE,
931: FND_GLOBAL.USER_ID)
932: RETURNING ARG_VALUE_ID INTO l_id;
933: x_arg_val_id := l_id;
934:
935: --exceptions passed to store

Line 958: last_updated_by = fnd_global.user_id,

954: --update the main args_b row
955: UPDATE fnd_oam_dscram_args_b
956: SET valid_value_flag = px_arg.valid_value_flag,
957: canonical_value = px_arg.canonical_value,
958: last_updated_by = fnd_global.user_id,
959: last_update_login = fnd_global.user_id,
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

Line 959: last_update_login = fnd_global.user_id,

955: UPDATE fnd_oam_dscram_args_b
956: SET valid_value_flag = px_arg.valid_value_flag,
957: canonical_value = px_arg.canonical_value,
958: last_updated_by = fnd_global.user_id,
959: last_update_login = fnd_global.user_id,
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

Line 967: last_updated_by = fnd_global.user_id,

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,
969: last_update_date = SYSDATE
970: WHERE arg_id = px_arg.arg_id
971: AND parent_type = FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_WORKER AND

Line 968: last_update_login = fnd_global.user_id,

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,
969: last_update_date = SYSDATE
970: WHERE arg_id = px_arg.arg_id
971: AND parent_type = FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_WORKER AND
972: parent_id = FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKER_ID;

Line 989: last_updated_by = fnd_global.user_id,

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,
989: last_updated_by = fnd_global.user_id,
990: last_update_login = fnd_global.user_id,
991: last_update_date = SYSDATE
992: WHERE arg_id = px_arg.arg_id AND
993: parent_type = FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_RANGE AND

Line 990: last_update_login = fnd_global.user_id,

986: canonical_value = px_arg.canonical_value,
987: rowid_lbound = px_arg.rowid_lbound,
988: rowid_ubound = px_arg.rowid_ubound,
989: last_updated_by = fnd_global.user_id,
990: last_update_login = fnd_global.user_id,
991: last_update_date = SYSDATE
992: WHERE arg_id = px_arg.arg_id AND
993: parent_type = FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_RANGE AND
994: rowid_lbound = px_arg.rowid_lbound AND

Line 1808: last_updated_by = fnd_global.user_id,

1804: l_ctxt VARCHAR2(60) := PKG_NAME||'RESET_INITIALIZED_AUTONOMOUSLY';
1805: BEGIN
1806: UPDATE fnd_oam_dscram_args_b
1807: SET initialized_success_flag = NULL,
1808: last_updated_by = fnd_global.user_id,
1809: last_update_login = fnd_global.user_id,
1810: last_update_date = SYSDATE
1811: WHERE arg_id = p_arg_id;
1812: COMMIT;

Line 1809: last_update_login = fnd_global.user_id,

1805: BEGIN
1806: UPDATE fnd_oam_dscram_args_b
1807: SET initialized_success_flag = NULL,
1808: last_updated_by = fnd_global.user_id,
1809: last_update_login = fnd_global.user_id,
1810: last_update_date = SYSDATE
1811: WHERE arg_id = p_arg_id;
1812: COMMIT;
1813: EXCEPTION