DBA Data[Home] [Help]

APPS.IGS_GE_GEN_001 dependencies on STANDARD

Line 327: -- 18/03/1998 YSWONG Modified code according to PLSQL-CODING standards

323: -------------------------------------------------------------------------------
324: -- 03/03/1998 MSONTER Intial creation of Module
325: -- 05/03/1998 MSONTER Modified cursor c_pa to search
326: -- IGS_CO_ADDR_TYPE.correspondence_type = 'Y'
327: -- 18/03/1998 YSWONG Modified code according to PLSQL-CODING standards
328: -- 19/03/1998 MSONTER Modified p_surname to p_name_style to use predefined
329: -- naming standards
330: -------------------------------------------------------------------------------
331: FUNCTION genp_get_per_addr(

Line 329: -- naming standards

325: -- 05/03/1998 MSONTER Modified cursor c_pa to search
326: -- IGS_CO_ADDR_TYPE.correspondence_type = 'Y'
327: -- 18/03/1998 YSWONG Modified code according to PLSQL-CODING standards
328: -- 19/03/1998 MSONTER Modified p_surname to p_name_style to use predefined
329: -- naming standards
330: -------------------------------------------------------------------------------
331: FUNCTION genp_get_per_addr(
332: p_per_id NUMBER,
333: p_adr_type VARCHAR2,

Line 520: -- 18/03/1998 YSWONG Modified code according to PLSQL-CODING standards

516: -------------------------------------------------------------------------------
517: -- 03/03/1998 MSONTER Intial creation of Module
518: -- 05/03/1998 MSONTER Modified cursor c_org_name to search
519: -- IGS_CO_ADDR_TYPE.correspondence_type = 'Y'
520: -- 18/03/1998 YSWONG Modified code according to PLSQL-CODING standards
521: -------------------------------------------------------------------------------
522: FUNCTION genp_get_org_addr(
523: p_org_unit_cd VARCHAR2,
524: p_addr_type VARCHAR2,

Line 650: -- 18/03/1998 YSWONG Modified code according to PLSQL-CODING standards

646: -------------------------------------------------------------------------------
647: -- 04/03/1998 MSONTER Intial creation of Module
648: -- 05/03/1998 MSONTER Modified cursor c_loc_name to search
649: -- IGS_CO_ADDR_TYPE.correspondence_type = 'Y'
650: -- 18/03/1998 YSWONG Modified code according to PLSQL-CODING standards
651: -------------------------------------------------------------------------------
652: FUNCTION genp_get_loc_addr(
653: p_location_cd VARCHAR2,
654: p_addr_type VARCHAR2,

Line 795: -- 18/03/1998 YSWONG Modified code according to PLSQL-CODING standards

791: ----------------------------------------------------------------------
792: -- 04/03/1998 MSONTER Intial creation of Module
793: -- 05/03/1998 MSONTER Modified cursor c_inst_name to search
794: -- IGS_CO_ADDR_TYPE.correspondence_type = 'Y'
795: -- 18/03/1998 YSWONG Modified code according to PLSQL-CODING standards
796: -- 19/03/1998 MSONTER Moved to local function of genp_get_addr
797: -------------------------------------------------------------------------------
798: FUNCTION genp_get_inst_addr(
799: p_institution_cd VARCHAR2,