APPS.ARI_SELF_REGISTRATION_PKG dependencies on ARI_REG_VERIFY_PKG

Line 2513: ARI_REG_VERIFY_PKG.Update_Row(x_Registration_id => l_registration_id,

2509: l_debug_info := 'RegId IN ADD CUST ACCESS----'||l_registration_id;
2510: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,l_debug_info);
2511: end if;
2512: -----------------------------------------------------------------------
2513: ARI_REG_VERIFY_PKG.Update_Row(x_Registration_id => l_registration_id,
2514: x_Status_Lookup_Code => 'COMPLETE',
2515: x_Last_Update_Date => sysdate);
2516: COMMIT;
2517:

Line 2857: ARI_REG_VERIFY_PKG.Update_Row(x_Registration_id => p_registration_id,

2853: WF_ENGINE.setitemattrevent ('ARIADDAC',
2854: l_item_key,
2855: 'ADD_ACCESS_DATA',
2856: l_event);
2857: ARI_REG_VERIFY_PKG.Update_Row(x_Registration_id => p_registration_id,
2858: x_Wf_Item_Key => l_item_key,
2859: x_Status_Lookup_Code => 'IN PROGRESS',
2860: x_Last_Update_Date => sysdate);
2861: ----------------------------------------------------------------------------------------

Line 2982: ARI_REG_VERIFY_PKG.Update_Row(x_Registration_id => l_registration_id,

2978: end if;
2979: -------------------------------------------------------------------------
2980: --Added if condition for Bug#16475167
2981: if(l_registration_id IS NOT NULL AND l_item_key IS NOT NULL) then
2982: ARI_REG_VERIFY_PKG.Update_Row(x_Registration_id => l_registration_id,
2983: x_Wf_Item_Key => l_item_key,
2984: x_Status_Lookup_Code => 'IN PROGRESS',
2985: x_Last_Update_Date => sysdate);
2986: COMMIT;

Line 3056: ARI_REG_VERIFY_PKG.Update_Row(x_Registration_id => l_registration_id,

3052: end if;
3053: end if;
3054: --Added if condition for Bug#16475167
3055: if(l_registration_id IS NOT NULL AND l_status IS NOT NULL)then
3056: ARI_REG_VERIFY_PKG.Update_Row(x_Registration_id => l_registration_id,
3057: x_Status_Lookup_Code => l_status,
3058: x_Last_Update_Date => sysdate);
3059: COMMIT;
3060: end if;

Line 3515: ARI_REG_VERIFY_PKG.Update_Row(x_Registration_id => p_registration_id,

3511: IF (PG_DEBUG = 'Y') THEN
3512: arp_standard.debug(G_PKG_NAME || l_procedure_name || '+');
3513: END IF;
3514:
3515: ARI_REG_VERIFY_PKG.Update_Row(x_Registration_id => p_registration_id,
3516: x_Status_Lookup_Code => G_RETRY,
3517: x_Missed_Cust_Question_Count => 0,
3518: x_Missed_Billto_Question_Count => 0);
3519:

Line 3616: ARI_REG_VERIFY_PKG.Insert_Row(

3612: ----------------------------------------------------------------------------
3613: IF (PG_DEBUG = 'Y') THEN
3614: arp_standard.debug(l_debug_info);
3615: END IF;
3616: ARI_REG_VERIFY_PKG.Insert_Row(
3617: x_Rowid => l_rowid,
3618: x_Registration_Id => p_registration_id,
3619: x_Application_Code => p_application_code,
3620: x_User_Email_Addr => upper(p_user_email_addr), -- Modified as a part of Bug# 13869981

Line 3742: ARI_REG_VERIFY_PKG.Update_Row(x_Registration_id => p_registration_id,

3738:
3739: --------------------------------------------------------------------
3740: l_debug_info := 'Open p_cust_acct_cur';
3741: --------------------------------------------------------------------
3742: ARI_REG_VERIFY_PKG.Update_Row(x_Registration_id => p_registration_id,
3743: x_Status_Lookup_Code => p_status);
3744: COMMIT;
3745: EXCEPTION
3746: WHEN OTHERS THEN

Line 3782: ARI_REG_VERIFY_PKG.Update_Row(x_Registration_id => p_registration_id,

3778: END IF;
3779: --------------------------------------------------------------------
3780: l_debug_info := 'Open p_cust_acct_cur';
3781: --------------------------------------------------------------------
3782: ARI_REG_VERIFY_PKG.Update_Row(x_Registration_id => p_registration_id,
3783: x_Missed_Cust_Question_Count => p_missed_cust_count,
3784: x_Missed_Billto_Question_Count => p_missed_billto_count,
3785: x_Last_Update_Date => sysdate);
3786: COMMIT;

Line 3823: ARI_REG_VERIFY_PKG.Update_Row(x_Registration_id => p_registration_id,

3819: END IF;
3820: --------------------------------------------------------------------
3821: l_debug_info := 'Open p_cust_acct_cur';
3822: --------------------------------------------------------------------
3823: ARI_REG_VERIFY_PKG.Update_Row(x_Registration_id => p_registration_id,
3824: x_Access_Domain_Billto_Id => p_access_domain_billto_id,
3825: x_Last_Update_Date => sysdate);
3826: COMMIT;
3827: EXCEPTION

Line 3878: ARI_REG_VERIFY_PKG.Update_Row(x_Registration_id => p_registration_id,

3874: l_debug_info := 'UpdateRequestAccess param values --- '||p_registration_id||p_registration_type||p_registration_status;
3875: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,l_debug_info);
3876: end if;
3877: ---------------------------------------------------------------------
3878: ARI_REG_VERIFY_PKG.Update_Row(x_Registration_id => p_registration_id,
3879: x_Registration_Type => p_registration_type,
3880: x_Status_Lookup_Code => p_registration_status,
3881: x_Last_Update_Date => sysdate);
3882: COMMIT;