DBA Data[Home] [Help]

APPS.JL_ZZ_AP_AWT_DEFAULT_PKG dependencies on JG_ZZ_SHARED_PKG

Line 765: v_country_code := JG_ZZ_SHARED_PKG.GET_COUNTRY(db_reg.org_id);

761: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Supp_Wh_Def_Line','Inside ELSIF db_reg.jurisdiction_type = MUNICIPAL THEN');
762: END IF;
763:
764: -- bug 11666467: Getting Country Code
765: v_country_code := JG_ZZ_SHARED_PKG.GET_COUNTRY(db_reg.org_id);
766:
767: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
768: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Supp_Wh_Def_Line','Country_code = '||nvl(v_country_code,'**NULL**'));
769: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Supp_Wh_Def_Line','Selecting City Code from Geography Model:');

Line 1466: Select JG_ZZ_SHARED_PKG.GET_COUNTRY(l_org_id, null)

1462: For C_Inv_Rec In C_Inv (P_Invoice_Id) Loop
1463: l_org_id := C_Inv_Rec.Org_id;
1464: l_invoice_type_lookup_code := C_Inv_Rec.invoice_type_lookup_code;
1465:
1466: Select JG_ZZ_SHARED_PKG.GET_COUNTRY(l_org_id, null)
1467: Into l_country_code
1468: From dual;
1469:
1470: If (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) Then