DBA Data[Home] [Help]

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 872: p_attributes in wf_parameter_list_t,

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

Line 893: l_params WF_PARAMETER_LIST_T;

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

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

907: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
908: l_modulePkg,
909: 'Begin propagate_user('||p_orig_system||', '||
910: p_orig_system_id||','||
911: 'p_attributes(wf_parameter_list_t)'||','||
912: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
913: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
914: end if;
915:

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

1522: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1523: l_modulePkg,
1524: 'End propagate_user('||p_orig_system||', '||
1525: p_orig_system_id||','||
1526: 'p_attributes(wf_parameter_list_t)'||','||
1527: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
1528: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
1529:
1530: end if;

Line 1560: p_attributes in wf_parameter_list_t,

1556: ** propagate_role -
1557: */
1558: PROCEDURE propagate_role(p_orig_system in varchar2,
1559: p_orig_system_id in number,
1560: p_attributes in wf_parameter_list_t,
1561: p_start_date in date,
1562: p_expiration_date in date) is
1563: l_status VARCHAR2(8);
1564: l_partitionName VARCHAR2(30);

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

1580: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1581: l_modulePkg,
1582: 'Begin propagate_role('||p_orig_system||', '||
1583: p_orig_system_id||','||
1584: 'p_attributes(wf_parameter_list_t)'||','||
1585: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
1586: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
1587:
1588: end if;

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

1846: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1847: l_modulePkg,
1848: 'End propagate_role('||p_orig_system||', '||
1849: p_orig_system_id||','||
1850: 'p_attributes(wf_parameter_list_t)'||','||
1851: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
1852: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
1853:
1854: end if;

Line 1982: p_attributes in WF_PARAMETER_LIST_T)

1978: p_creationDate in date,
1979: p_lastUpdateDate in date,
1980: p_assignmentReason in varchar2,
1981: p_UpdateWho in boolean,
1982: p_attributes in WF_PARAMETER_LIST_T)
1983: is
1984: l_uorigSys VARCHAR2(30);
1985: l_uorigSysID NUMBER;
1986: l_rorigSys VARCHAR2(30);