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.WF_LOCAL_SYNCH dependencies on WF_PARAMETER_LIST_T

Line 49: g_attributes WF_PARAMETER_LIST_T;

45: g_lastUpdatedBy NUMBER;
46: g_creationDate DATE;
47: g_createdBy NUMBER;
48: g_lastUpdateLogin NUMBER;
49: g_attributes WF_PARAMETER_LIST_T;
50: ------------------------------------------------------------------------------
51: /*
52: ** seedAttributes -
53: **

Line 56: procedure seedAttributes (p_attributes in wf_parameter_list_t,

52: ** seedAttributes -
53: **
54: ** This routine opens a parameter list and seeds role variables.
55: */
56: procedure seedAttributes (p_attributes in wf_parameter_list_t,
57: p_origSystem in VARCHAR2,
58: p_origSystemID in NUMBER,
59: p_expDate in DATE) is
60:

Line 69: '(wf_parameter_list_t), '||p_origSystem||', '||

65: -- Log only
66: -- BINDVAR_SCAN_IGNORE[5]
67: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
68: 'Begin seedAttributes(p_attributes '||
69: '(wf_parameter_list_t), '||p_origSystem||', '||
70: to_char(p_origSystemID)||', '||
71: to_char(p_expDate, WF_CORE.canonical_date_mask)||')');
72:
73: g_name := NULL;

Line 101: g_Attributes := wf_parameter_list_t();

97: g_lastUpdatedBy := WFA_SEC.user_id;
98: g_creationDate := sysdate;
99: g_createdBy := WFA_SEC.user_id;
100: g_lastUpdateLogin := WFA_SEC.login_id;
101: g_Attributes := wf_parameter_list_t();
102:
103:
104: FOR i in p_attributes.FIRST..p_attributes.LAST loop
105: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

Line 286: '(wf_parameter_list_t), '||p_origSystem||', '||

282: end if;
283:
284: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
285: 'End seedAttributes(p_attributes '||
286: '(wf_parameter_list_t), '||p_origSystem||', '||
287: to_char(p_origSystemID)||', '||
288: to_char(p_expDate, WF_CORE.canonical_date_mask)||')');
289:
290: exception

Line 326: p_attributes in wf_parameter_list_t,

322: ** This routine encapsulates the bit that keeps entmgr in the loop
323: */
324: PROCEDURE update_entmgr(p_entity_type in varchar2,
325: p_entity_key_value in varchar2,
326: p_attributes in wf_parameter_list_t,
327: p_source in varchar2) is
328: i number;
329: l_modulePkg varchar2(240) := g_modulePkg||'.update_entmgr';
330:

Line 337: 'p_attributes (wf_parameter_list_t)'||', '||

333:
334: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
335: 'Begin update_entmgr('|| p_entity_type||', '||
336: p_entity_key_value||', '||
337: 'p_attributes (wf_parameter_list_t)'||', '||
338: p_source||')');
339:
340:
341: end if;

Line 362: 'p_attributes(wf_parameter_list_t)'||', '||

358:
359: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
360: 'End update_entmgr('||p_entity_type||', '||
361: p_entity_key_value||', '||
362: 'p_attributes(wf_parameter_list_t)'||', '||
363: p_source||')');
364:
365: end if;
366:

Line 874: p_attributes in wf_parameter_list_t,

870: ** propagate_user -
871: */
872: PROCEDURE propagate_user(p_orig_system in varchar2,
873: p_orig_system_id in number,
874: p_attributes in wf_parameter_list_t,
875: p_start_date in date,
876: p_expiration_date in date) is
877:
878: cursor linked_per_users is

Line 895: l_params WF_PARAMETER_LIST_T;

891: l_partitionName varchar2(30);
892: l_oldOrigSystemID NUMBER;
893: l_status VARCHAR2(8);
894:
895: l_params WF_PARAMETER_LIST_T;
896: l_overWrite varchar2(2) :='N';
897: l_overWrite_UserRoles varchar2(2) :='N';
898: l_oldLastUpdDate date;
899: l_oldLastUpdLogin number;

Line 915: 'p_attributes(wf_parameter_list_t)'||','||

911: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
912: l_modulePkg,
913: 'Begin propagate_user('||p_orig_system||', '||
914: p_orig_system_id||','||
915: 'p_attributes(wf_parameter_list_t)'||','||
916: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
917: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
918: end if;
919:

Line 1534: 'p_attributes(wf_parameter_list_t)'||','||

1530: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1531: l_modulePkg,
1532: 'End propagate_user('||p_orig_system||', '||
1533: p_orig_system_id||','||
1534: 'p_attributes(wf_parameter_list_t)'||','||
1535: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
1536: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
1537:
1538: end if;

Line 1568: p_attributes in wf_parameter_list_t,

1564: ** propagate_role -
1565: */
1566: PROCEDURE propagate_role(p_orig_system in varchar2,
1567: p_orig_system_id in number,
1568: p_attributes in wf_parameter_list_t,
1569: p_start_date in date,
1570: p_expiration_date in date) is
1571: l_status VARCHAR2(8);
1572: l_partitionName VARCHAR2(30);

Line 1593: 'p_attributes(wf_parameter_list_t)'||','||

1589: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1590: l_modulePkg,
1591: 'Begin propagate_role('||p_orig_system||', '||
1592: p_orig_system_id||','||
1593: 'p_attributes(wf_parameter_list_t)'||','||
1594: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
1595: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
1596:
1597: end if;

Line 1899: 'p_attributes(wf_parameter_list_t)'||','||

1895: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1896: l_modulePkg,
1897: 'End propagate_role('||p_orig_system||', '||
1898: p_orig_system_id||','||
1899: 'p_attributes(wf_parameter_list_t)'||','||
1900: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
1901: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
1902:
1903: end if;

Line 2032: p_attributes in WF_PARAMETER_LIST_T)

2028: p_creationDate in date,
2029: p_lastUpdateDate in date,
2030: p_assignmentReason in varchar2,
2031: p_UpdateWho in boolean,
2032: p_attributes in WF_PARAMETER_LIST_T)
2033: is
2034: l_uorigSys VARCHAR2(30);
2035: l_uorigSysID NUMBER;
2036: l_rorigSys VARCHAR2(30);

Line 3006: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();

3002: where orig_system not in ('FND_USR', 'PER')
3003: and notification_preference = 'DISABLED'
3004: and nvl(EXPIRATION_DATE, sysdate+1) > sysdate;
3005:
3006: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
3007: l_prev_preference varchar2(8) := NULL;
3008: l_userName varchar2(360) := null;
3009:
3010: errname varchar2(30);