DBA Data[Home] [Help]

APPS.ASO_SECURITY_INT dependencies on FND_GLOBAL

Line 167: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

163: l_primary_resource_grp_id NUMBER;
164: l_access_id NUMBER;
165: l_exist_access_id NUMBER;
166:
167: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
168: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
169: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
170: l_x_status VARCHAR2(1);
171: l_qte_access_tbl Qte_Access_Tbl_Type := p_qte_access_tbl;

Line 168: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

164: l_access_id NUMBER;
165: l_exist_access_id NUMBER;
166:
167: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
168: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
169: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
170: l_x_status VARCHAR2(1);
171: l_qte_access_tbl Qte_Access_Tbl_Type := p_qte_access_tbl;
172:

Line 483: last_updated_by = fnd_global.user_id,

479:
480: UPDATE ASO_QUOTE_HEADERS_ALL
481: SET resource_grp_id = l_resource_grp_id,
482: last_update_date = sysdate,
483: last_updated_by = fnd_global.user_id,
484: last_update_login = fnd_global.conc_login_id
485: WHERE quote_number = l_quote_number
486: AND max_version_flag = 'Y';
487:

Line 484: last_update_login = fnd_global.conc_login_id

480: UPDATE ASO_QUOTE_HEADERS_ALL
481: SET resource_grp_id = l_resource_grp_id,
482: last_update_date = sysdate,
483: last_updated_by = fnd_global.user_id,
484: last_update_login = fnd_global.conc_login_id
485: WHERE quote_number = l_quote_number
486: AND max_version_flag = 'Y';
487:
488: IF SQL%ROWCOUNT = 0 THEN

Line 520: last_updated_by = fnd_global.user_id,

516: END IF;
517:
518: UPDATE ASO_QUOTE_HEADERS_ALL
519: SET last_update_date = sysdate,
520: last_updated_by = fnd_global.user_id,
521: last_update_login = fnd_global.conc_login_id
522: WHERE quote_number = l_quote_number AND
523: max_version_flag = 'Y';
524:

Line 521: last_update_login = fnd_global.conc_login_id

517:
518: UPDATE ASO_QUOTE_HEADERS_ALL
519: SET last_update_date = sysdate,
520: last_updated_by = fnd_global.user_id,
521: last_update_login = fnd_global.conc_login_id
522: WHERE quote_number = l_quote_number AND
523: max_version_flag = 'Y';
524:
525: IF SQL%ROWCOUNT = 0 THEN

Line 881: last_updated_by = fnd_global.user_id,

877: END IF;
878:
879: UPDATE ASO_QUOTE_HEADERS_ALL
880: SET last_update_date = sysdate,
881: last_updated_by = fnd_global.user_id,
882: last_update_login = fnd_global.conc_login_id
883: WHERE quote_number = l_quote_number AND
884: max_version_flag = 'Y';
885:

Line 882: last_update_login = fnd_global.conc_login_id

878:
879: UPDATE ASO_QUOTE_HEADERS_ALL
880: SET last_update_date = sysdate,
881: last_updated_by = fnd_global.user_id,
882: last_update_login = fnd_global.conc_login_id
883: WHERE quote_number = l_quote_number AND
884: max_version_flag = 'Y';
885:
886: IF SQL%ROWCOUNT = 0 THEN

Line 1003: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

999: c_profile_value Varchar2(2000);
1000: l_qte_access_rec Qte_Access_Rec_Type := G_MISS_QTE_ACCESS_REC;
1001: l_qte_access_tbl Qte_Access_Tbl_Type := G_MISS_QTE_ACCESS_TBL;
1002: lx_qte_access_tbl Qte_Access_Tbl_Type;
1003: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1004: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1005: l_obsolete_status varchar2(1);
1006: BEGIN
1007:

Line 1004: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

1000: l_qte_access_rec Qte_Access_Rec_Type := G_MISS_QTE_ACCESS_REC;
1001: l_qte_access_tbl Qte_Access_Tbl_Type := G_MISS_QTE_ACCESS_TBL;
1002: lx_qte_access_tbl Qte_Access_Tbl_Type;
1003: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1004: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1005: l_obsolete_status varchar2(1);
1006: BEGIN
1007:
1008: IF aso_debug_pub.g_debug_flag = 'Y' THEN