DBA Data[Home] [Help]

APPS.ASO_SECURITY_INT dependencies on ASO_QUOTE_HEADERS_ALL

Line 144: FROM ASO_QUOTE_HEADERS_ALL

140:
141: CURSOR C_primary_resource (l_quote_number NUMBER) IS
142: SELECT resource_id,quote_header_id,
143: resource_grp_id
144: FROM ASO_QUOTE_HEADERS_ALL
145: WHERE quote_number = l_quote_number
146: AND max_version_flag = 'Y';
147:
148: cursor c_access_id_exist( p_access_id number) is

Line 155: ASO_QUOTE_HEADERS_ALL where quote_number = p_qte_number

151: where access_id = p_access_id;
152:
153: CURSOR Lock_check(p_qte_number Number)
154: IS SELECT price_request_id FROM
155: ASO_QUOTE_HEADERS_ALL where quote_number = p_qte_number
156: AND max_version_flag = 'Y';
157:
158: l_quote_number NUMBER;
159: l_resource_id NUMBER;

Line 477: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: before update ASO_QUOTE_HEADERS_ALL', 1, 'Y');

473: ELSE
474: IF l_resource_grp_id IS NOT NULL AND l_resource_grp_id <> FND_API.G_MISS_NUM THEN
475: IF l_primary_resource_grp_id <> l_resource_grp_id THEN
476: IF aso_debug_pub.g_debug_flag = 'Y' THEN
477: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: before update ASO_QUOTE_HEADERS_ALL', 1, 'Y');
478: END IF;
479:
480: UPDATE ASO_QUOTE_HEADERS_ALL
481: SET resource_grp_id = l_resource_grp_id,

Line 480: UPDATE ASO_QUOTE_HEADERS_ALL

476: IF aso_debug_pub.g_debug_flag = 'Y' THEN
477: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: before update ASO_QUOTE_HEADERS_ALL', 1, 'Y');
478: END IF;
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

Line 490: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: inside update ASO_QUOTE_HEADERS_ALL: SQL%ROWCOUNT = 0', 1, 'Y');

486: AND max_version_flag = 'Y';
487:
488: IF SQL%ROWCOUNT = 0 THEN
489: IF aso_debug_pub.g_debug_flag = 'Y' THEN
490: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: inside update ASO_QUOTE_HEADERS_ALL: SQL%ROWCOUNT = 0', 1, 'Y');
491: END IF;
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: RAISE FND_API.G_EXC_ERROR;
494: END IF;

Line 497: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: after update ASO_QUOTE_HEADERS_ALL', 1, 'Y');

493: RAISE FND_API.G_EXC_ERROR;
494: END IF;
495:
496: IF aso_debug_pub.g_debug_flag = 'Y' THEN
497: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: after update ASO_QUOTE_HEADERS_ALL', 1, 'Y');
498: END IF;
499:
500: END IF;
501: END IF;

Line 514: aso_debug_pub.add('ASO_SECURITY_INT: End of Add_Resource: before update ASO_QUOTE_HEADERS_ALL', 1, 'Y');

510:
511: END LOOP;
512:
513: IF aso_debug_pub.g_debug_flag = 'Y' THEN
514: aso_debug_pub.add('ASO_SECURITY_INT: End of Add_Resource: before update ASO_QUOTE_HEADERS_ALL', 1, 'Y');
515: aso_debug_pub.add('ASO_SECURITY_INT: End of Add_Resource: l_quote_number: '||l_quote_number, 1, 'Y');
516: END IF;
517:
518: UPDATE ASO_QUOTE_HEADERS_ALL

Line 518: UPDATE ASO_QUOTE_HEADERS_ALL

514: aso_debug_pub.add('ASO_SECURITY_INT: End of Add_Resource: before update ASO_QUOTE_HEADERS_ALL', 1, 'Y');
515: aso_debug_pub.add('ASO_SECURITY_INT: End of Add_Resource: l_quote_number: '||l_quote_number, 1, 'Y');
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

Line 527: aso_debug_pub.add('ASO_SECURITY_INT: End of Add_Resource: after update ASO_QUOTE_HEADERS_ALL: SQL%ROWCOUNT = 0', 1, 'Y');

523: max_version_flag = 'Y';
524:
525: IF SQL%ROWCOUNT = 0 THEN
526: IF aso_debug_pub.g_debug_flag = 'Y' THEN
527: aso_debug_pub.add('ASO_SECURITY_INT: End of Add_Resource: after update ASO_QUOTE_HEADERS_ALL: SQL%ROWCOUNT = 0', 1, 'Y');
528: END IF;
529: x_return_status := FND_API.G_RET_STS_ERROR;
530: RAISE FND_API.G_EXC_ERROR;
531: END IF;

Line 675: FROM ASO_QUOTE_HEADERS_ALL

671: WHERE access_id = l_access_id;
672:
673: CURSOR C_primary_resource (l_quote_number NUMBER) IS
674: SELECT resource_id
675: FROM ASO_QUOTE_HEADERS_ALL
676: WHERE quote_number = l_quote_number
677: AND max_version_flag = 'Y';
678:
679: CURSOR C_Lock_check(p_qte_number Number)

Line 681: ASO_QUOTE_HEADERS_ALL where quote_number = p_qte_number

677: AND max_version_flag = 'Y';
678:
679: CURSOR C_Lock_check(p_qte_number Number)
680: IS SELECT price_request_id FROM
681: ASO_QUOTE_HEADERS_ALL where quote_number = p_qte_number
682: AND max_version_flag = 'Y';
683:
684: CURSOR C_Quote_num(p_access_id Number) IS
685: SELECT quote_number FROM

Line 876: aso_debug_pub.add('ASO_SECURITY_INT: End of Delete_Resource: before update ASO_QUOTE_HEADERS_ALL', 1, 'Y');

872:
873: END LOOP;
874:
875: IF aso_debug_pub.g_debug_flag = 'Y' THEN
876: aso_debug_pub.add('ASO_SECURITY_INT: End of Delete_Resource: before update ASO_QUOTE_HEADERS_ALL', 1, 'Y');
877: END IF;
878:
879: UPDATE ASO_QUOTE_HEADERS_ALL
880: SET last_update_date = sysdate,

Line 879: UPDATE ASO_QUOTE_HEADERS_ALL

875: IF aso_debug_pub.g_debug_flag = 'Y' THEN
876: aso_debug_pub.add('ASO_SECURITY_INT: End of Delete_Resource: before update ASO_QUOTE_HEADERS_ALL', 1, 'Y');
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

Line 888: aso_debug_pub.add('ASO_SECURITY_INT: End of Delete_Resource: after update ASO_QUOTE_HEADERS_ALL: SQL%ROWCOUNT = 0', 1, 'Y');

884: max_version_flag = 'Y';
885:
886: IF SQL%ROWCOUNT = 0 THEN
887: IF aso_debug_pub.g_debug_flag = 'Y' THEN
888: aso_debug_pub.add('ASO_SECURITY_INT: End of Delete_Resource: after update ASO_QUOTE_HEADERS_ALL: SQL%ROWCOUNT = 0', 1, 'Y');
889: END IF;
890: x_return_status := FND_API.G_RET_STS_ERROR;
891: RAISE FND_API.G_EXC_ERROR;
892: END IF;