49: );
50:
51:
52: TYPE OWNER_RSC_REC_TYPE IS RECORD(
53: resource_id jtf_tty_terr_grp_owners.resource_id%TYPE,
54: group_id jtf_tty_terr_grp_owners.rsc_group_id%TYPE,
55: role_code jtf_tty_terr_grp_owners.rsc_role_code%TYPE,
56: delete_flag VARCHAR2(1)
57: );
50:
51:
52: TYPE OWNER_RSC_REC_TYPE IS RECORD(
53: resource_id jtf_tty_terr_grp_owners.resource_id%TYPE,
54: group_id jtf_tty_terr_grp_owners.rsc_group_id%TYPE,
55: role_code jtf_tty_terr_grp_owners.rsc_role_code%TYPE,
56: delete_flag VARCHAR2(1)
57: );
58: TYPE OWNER_RSC_TBL_TYPE IS TABLE OF OWNER_RSC_REC_TYPE;
51:
52: TYPE OWNER_RSC_REC_TYPE IS RECORD(
53: resource_id jtf_tty_terr_grp_owners.resource_id%TYPE,
54: group_id jtf_tty_terr_grp_owners.rsc_group_id%TYPE,
55: role_code jtf_tty_terr_grp_owners.rsc_role_code%TYPE,
56: delete_flag VARCHAR2(1)
57: );
58: TYPE OWNER_RSC_TBL_TYPE IS TABLE OF OWNER_RSC_REC_TYPE;
59: TYPE SALESREP_RSC_TBL_TYPE IS TABLE OF SALESREP_RSC_REC_TYPE;