DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on AP_AWT_GROUPS

Line 1019: l_dummy_id AP_AWT_GROUPS.group_id%TYPE;

1015: p_allow_awt_flag IN VARCHAR2,
1016: x_valid OUT NOCOPY BOOLEAN
1017: ) IS
1018:
1019: l_dummy_id AP_AWT_GROUPS.group_id%TYPE;
1020: l_dummy_name AP_AWT_GROUPS.name%TYPE;
1021:
1022: BEGIN
1023: x_valid := TRUE;

Line 1020: l_dummy_name AP_AWT_GROUPS.name%TYPE;

1016: x_valid OUT NOCOPY BOOLEAN
1017: ) IS
1018:
1019: l_dummy_id AP_AWT_GROUPS.group_id%TYPE;
1020: l_dummy_name AP_AWT_GROUPS.name%TYPE;
1021:
1022: BEGIN
1023: x_valid := TRUE;
1024:

Line 1050: FROM AP_AWT_GROUPS

1046: BEGIN
1047:
1048: SELECT name
1049: INTO l_dummy_name
1050: FROM AP_AWT_GROUPS
1051: WHERE group_id = p_awt_id
1052: AND sysdate < nvl(inactive_date, sysdate + 1);
1053:
1054: EXCEPTION

Line 1068: FROM AP_AWT_GROUPS

1064: BEGIN
1065:
1066: SELECT group_id
1067: INTO l_dummy_id
1068: FROM AP_AWT_GROUPS
1069: WHERE group_id = p_awt_id
1070: AND name = p_awt_name
1071: AND sysdate < nvl(inactive_date, sysdate + 1);
1072:

Line 1088: FROM AP_AWT_GROUPS

1084: BEGIN
1085:
1086: SELECT group_id
1087: INTO p_awt_id
1088: FROM AP_AWT_GROUPS
1089: WHERE name = p_awt_name
1090: AND sysdate < nvl(inactive_date, sysdate + 1);
1091:
1092: EXCEPTION