eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_APPROVAL_PVT dependencies on OZF_SD_REQUEST_ACCESS

Line 2039: FROM OZF_SD_REQUEST_ACCESS

2035: AND rownum < 2;
2036:
2037: CURSOR csr_get_approver_count(p_object_id IN NUMBER )IS
2038: SELECT count(*)
2039: FROM OZF_SD_REQUEST_ACCESS
2040: WHERE request_header_id = p_object_id
2041: AND approver_flag = 'Y'
2042: AND enabled_flag = 'Y';
2043:

Line 2067: -- and populate OZF_SD_REQUEST_ACCESS table

2063: END IF;
2064: -- Initialize API return status to sucess
2065: x_return_status := FND_API.G_RET_STS_SUCCESS;
2066: -- If action code is SUBMIT get the approver list from AME setup
2067: -- and populate OZF_SD_REQUEST_ACCESS table
2068: IF (p_action_code = 'SUBMIT') THEN
2069: IF G_DEBUG THEN
2070: ozf_utility_pvt.debug_message( 'Get Approvers for request_header_id: ' || p_object_id );
2071: END IF;

Line 2114: -- insert the record in OZF_SD_REQUEST_ACCESS table

2110: l_insert_mode := 'N';
2111: END IF;
2112: END IF;
2113: -- This procedure will do required validation and
2114: -- insert the record in OZF_SD_REQUEST_ACCESS table
2115: IF (l_insert_mode = 'Y') THEN
2116: IF G_DEBUG THEN
2117: ozf_utility_pvt.debug_message( 'Invoke Add_SD_Access for AME approver: ' || l_orig_system_id);
2118: END IF;

Line 2367: -- OZF_SD_REQUEST_ACCESS table.

2363: -- PURPOSE
2364: -- This procedure has been created for Ship & Debit Request.
2365: -- This procedure performs the required validation and invokes the
2366: -- overloaded procedure which finally adds the record into
2367: -- OZF_SD_REQUEST_ACCESS table.
2368: --
2369: -- PARAMETERS
2370: --
2371: -- NOTES

Line 2582: -- the record into OZF_SD_REQUEST_ACCESS table.

2578: --
2579: -- PURPOSE
2580: -- This procedure has been created for Ship & Debit Request.
2581: -- This procedure performs the required business logic and adds
2582: -- the record into OZF_SD_REQUEST_ACCESS table.
2583: --
2584: -- PARAMETERS
2585: --
2586: -- NOTES

Line 2612: SELECT OZF_SD_REQUEST_ACCESS_S.NEXTVAL

2608: l_exist_version_number NUMBER;
2609: l_insert_mode VARCHAR2(1) := 'N';
2610:
2611: CURSOR c_id IS
2612: SELECT OZF_SD_REQUEST_ACCESS_S.NEXTVAL
2613: FROM dual;
2614:
2615: CURSOR CSR_EXISTING_OWNER (p_object_id IN NUMBER) IS
2616: SELECT resource_id, user_id, approver_flag, object_version_number

Line 2617: FROM OZF_SD_REQUEST_ACCESS

2613: FROM dual;
2614:
2615: CURSOR CSR_EXISTING_OWNER (p_object_id IN NUMBER) IS
2616: SELECT resource_id, user_id, approver_flag, object_version_number
2617: FROM OZF_SD_REQUEST_ACCESS
2618: WHERE request_header_id = p_object_id
2619: AND enabled_flag = 'Y'
2620: AND owner_flag = 'Y';
2621:

Line 2624: FROM OZF_SD_REQUEST_ACCESS

2620: AND owner_flag = 'Y';
2621:
2622: CURSOR CSR_EXISTING_OWNER_APPROVER(p_object_id IN NUMBER, p_resource_id IN NUMBER) IS
2623: SELECT resource_id, owner_flag, approver_flag, object_version_number
2624: FROM OZF_SD_REQUEST_ACCESS
2625: WHERE request_header_id = p_object_id
2626: AND enabled_flag = 'Y'
2627: AND resource_id = p_resource_id;
2628:

Line 2664: UPDATE OZF_SD_REQUEST_ACCESS

2660: l_exist_version_number;
2661: CLOSE CSR_EXISTING_OWNER_APPROVER;
2662: IF l_exist_resource_id IS NOT NULL THEN
2663: IF (l_exist_owner_flag = 'Y' AND l_exist_approver_flag IS NULL)THEN
2664: UPDATE OZF_SD_REQUEST_ACCESS
2665: SET approver_flag = 'Y',
2666: object_version_number = l_exist_version_number + 1
2667: WHERE request_header_id = p_access_rec.REQUEST_HEADER_ID
2668: AND resource_id = p_access_rec.RESOURCE_ID

Line 2691: UPDATE OZF_SD_REQUEST_ACCESS

2687: -- dont update anything
2688: IF (l_exist_resource_id IS NOT NULL) THEN
2689: IF (l_exist_resource_id <> p_access_rec.RESOURCE_ID AND l_exist_user_id <> p_access_rec.USER_ID) THEN
2690: IF l_exist_approver_flag IS NULL THEN
2691: UPDATE OZF_SD_REQUEST_ACCESS
2692: SET enabled_flag = NULL,
2693: object_version_number = l_exist_version_number + 1
2694: WHERE request_header_id = p_access_rec.REQUEST_HEADER_ID
2695: AND resource_id = l_exist_resource_id

Line 2698: UPDATE OZF_SD_REQUEST_ACCESS

2694: WHERE request_header_id = p_access_rec.REQUEST_HEADER_ID
2695: AND resource_id = l_exist_resource_id
2696: AND enabled_flag = 'Y';
2697: ELSE
2698: UPDATE OZF_SD_REQUEST_ACCESS
2699: SET owner_flag = NULL,
2700: object_version_number = l_exist_version_number + 1
2701: WHERE request_header_id = p_access_rec.REQUEST_HEADER_ID
2702: AND resource_id = l_exist_resource_id

Line 2723: UPDATE OZF_SD_REQUEST_ACCESS

2719: l_exist_approver_flag,
2720: l_exist_version_number;
2721: CLOSE CSR_EXISTING_OWNER_APPROVER;
2722: IF (l_exist_resource_id IS NOT NULL AND l_exist_approver_flag = 'Y') THEN
2723: UPDATE OZF_SD_REQUEST_ACCESS
2724: SET owner_flag = 'Y',
2725: object_version_number = l_exist_version_number + 1
2726: WHERE request_header_id = p_access_rec.REQUEST_HEADER_ID
2727: AND resource_id = p_access_rec.RESOURCE_ID

Line 2741: ozf_utility_pvt.debug_message( 'Inserting data into OZF_SD_REQUEST_ACCESS table');

2737:
2738: IF (l_insert_mode = 'Y') THEN
2739: BEGIN
2740: IF G_DEBUG THEN
2741: ozf_utility_pvt.debug_message( 'Inserting data into OZF_SD_REQUEST_ACCESS table');
2742: END IF;
2743: -- GET PRIMARY KEY
2744: OPEN c_id;
2745: FETCH c_id INTO l_approval_access_id;

Line 2747: INSERT INTO OZF_SD_REQUEST_ACCESS(

2743: -- GET PRIMARY KEY
2744: OPEN c_id;
2745: FETCH c_id INTO l_approval_access_id;
2746: CLOSE c_id;
2747: INSERT INTO OZF_SD_REQUEST_ACCESS(
2748: request_access_id
2749: ,request_header_id
2750: ,user_id
2751: ,resource_id

Line 2976: FROM ozf_sd_request_access ora,

2972: l_api_version CONSTANT NUMBER := 1.0;
2973:
2974: CURSOR csr_approvers (p_object_id IN NUMBER) IS
2975: SELECT fu.user_name
2976: FROM ozf_sd_request_access ora,
2977: fnd_user fu
2978: WHERE ora.request_header_id = p_object_id
2979: AND ora.person_id IS NULL
2980: AND ora.user_id = fu.user_id

Line 2985: FROM ozf_sd_request_access ora,

2981: AND ora.approver_flag = 'Y'
2982: AND ora.enabled_flag = 'Y'
2983: UNION
2984: SELECT jre.user_name
2985: FROM ozf_sd_request_access ora,
2986: jtf_rs_resource_extns jre
2987: WHERE ora.request_header_id = p_object_id
2988: AND ora.person_id IS NOT NULL
2989: AND ora.person_id = jre.source_id

Line 2996: FROM ozf_sd_request_access ora,

2992: GROUP BY jre.user_name;
2993:
2994: CURSOR csr_access_members(p_object_id IN NUMBER) IS
2995: SELECT fu.user_name
2996: FROM ozf_sd_request_access ora,
2997: fnd_user fu
2998: WHERE ora.request_header_id = p_object_id
2999: AND ora.person_id IS NULL
3000: AND ora.user_id = fu.user_id

Line 3004: FROM ozf_sd_request_access ora,

3000: AND ora.user_id = fu.user_id
3001: AND ora.enabled_flag = 'Y'
3002: UNION
3003: SELECT jre.user_name
3004: FROM ozf_sd_request_access ora,
3005: jtf_rs_resource_extns jre
3006: WHERE ora.request_header_id = p_object_id
3007: AND ora.person_id IS NOT NULL
3008: AND ora.person_id = jre.source_id