DBA Data[Home] [Help]

APPS.ZPB_DC_OBJECTS_PVT dependencies on FND_RESPONSIBILITY

Line 1446: l_resp_key fnd_responsibility.responsibility_key%TYPE;

1442: l_user_id NUMBER;
1443: l_user zpb_task_parameters.value%TYPE;
1444: l_insert_type VARCHAR2(10);
1445: l_count NUMBER;
1446: l_resp_key fnd_responsibility.responsibility_key%TYPE;
1447:
1448: -- Get the all the parameter values for the task id
1449: CURSOR task_params_csr IS
1450: SELECT name, value

Line 1939: l_resp_key fnd_responsibility.responsibility_key%TYPE;

1935:
1936: l_pattern VARCHAR2(1);
1937: l_position BINARY_INTEGER;
1938: l_pattern_position BINARY_INTEGER;
1939: l_resp_key fnd_responsibility.responsibility_key%TYPE;
1940:
1941: -- Get template id and more
1942: CURSOR template_info_csr IS
1943: SELECT template_id,

Line 2431: l_resp_key fnd_responsibility.responsibility_key%TYPE;

2427: l_recipient_type VARCHAR2(30);
2428: l_object_user_id NUMBER;
2429: l_template_id NUMBER;
2430: l_object_id NUMBER;
2431: l_resp_key fnd_responsibility.responsibility_key%TYPE;
2432: --
2433: l_amt INTEGER;
2434: l_buffer VARCHAR2(30);
2435: l_user_id_clob CLOB;

Line 2970: l_resp_key fnd_responsibility.responsibility_key%TYPE;

2966: l_charDate VARCHAR2(20);
2967: l_rolename VARCHAR2(320);
2968: l_recipient_type VARCHAR2(30);
2969: l_object_user_id NUMBER;
2970: l_resp_key fnd_responsibility.responsibility_key%TYPE;
2971: --
2972: l_amt INTEGER;
2973: l_buffer VARCHAR2(30);
2974: l_user_id_clob CLOB;