[Home] [Help]
1017: --
1018: -- VALIDATE_CONTEXT
1019: -- Introduced because of bug 7914921
1020: -- Gets a noification contexts and derives the item type, key and activity ID, if any
1021: -- Since the standard format itemtype:itemkey:actid is NOT mandatory this function
1022: -- returns null values if the context does not meet the standard. Further validation is
1023: -- requried by the calling program
1024: -- IN
1025: -- context: the notification context to validate
1018: -- VALIDATE_CONTEXT
1019: -- Introduced because of bug 7914921
1020: -- Gets a noification contexts and derives the item type, key and activity ID, if any
1021: -- Since the standard format itemtype:itemkey:actid is NOT mandatory this function
1022: -- returns null values if the context does not meet the standard. Further validation is
1023: -- requried by the calling program
1024: -- IN
1025: -- context: the notification context to validate
1026: -- IN OUT
1043: col2 := instr(context, ':', -1, 1);
1044: if col1>0 AND col2>col1 then --Context seems to have itemtype and key
1045: itemtype := substr(context, 1, col1-1);
1046: itemkey := substr(context, col1+1, col2-col1-1);
1047: if LENGTH(itemtype)<=8 then --Standard lenght for a valid item type
1048: BEGIN
1049: actid:=to_number(substr(context, col2+1));
1050: EXCEPTION
1051: WHEN OTHERS THEN --covers for an invalid conversion to number.
3427: l_actid number;
3428: begin
3429:
3430: -- Derive item type, item key and activity id from the context
3431: -- when no ':' or just one ':', context does not conform to WF standard
3432: -- it could be sent by calling wf_notification.send directly
3433: -- in this case, we just return false to preserve the old behavior
3434: validate_context (p_context, l_item_type, l_item_key, l_actid);
3435: if (l_item_type is null or l_item_key is null or l_actid is null) then