4: G_SEARCH_CURSOR NUMBER := dbms_sql.open_cursor;
5: G_SEARCH_STMT LONG;
6: G_PKG_NAME VARCHAR2(30);
7: G_FILE_NAME VARCHAR2(12);
8: G_USER_ID fnd_user.user_id%TYPE;
9: G_PARTY_ID hz_parties.party_id%TYPE;
10: G_LOGIN_ID fnd_user.last_update_login%TYPE;
11: G_SESSION_LANG VARCHAR2(99);
12:
6: G_PKG_NAME VARCHAR2(30);
7: G_FILE_NAME VARCHAR2(12);
8: G_USER_ID fnd_user.user_id%TYPE;
9: G_PARTY_ID hz_parties.party_id%TYPE;
10: G_LOGIN_ID fnd_user.last_update_login%TYPE;
11: G_SESSION_LANG VARCHAR2(99);
12:
13:
14: /*