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.CZ_UIOA_PVT dependencies on CZ_UI_ACTIONS

Line 738: SELECT CZ_UI_ACTIONS_S.nextval INTO g_currentUIAction FROM dual;

734:
735: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currentPageSet FROM dual;
736: g_currPageSetSeqVal := g_currentPageSet;
737:
738: SELECT CZ_UI_ACTIONS_S.nextval INTO g_currentUIAction FROM dual;
739: g_currUIActionSeqVal := g_currentUIAction;
740:
741: END Initialize_Sequences;
742:

Line 1050: ELSIF p_sequence_name='CZ_UI_ACTIONS_S' THEN

1046: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currPageSetSeqVal FROM dual;
1047: g_currentPageSet := g_currPageSetSeqVal;
1048: END IF;
1049: RETURN g_currentPageSet;
1050: ELSIF p_sequence_name='CZ_UI_ACTIONS_S' THEN
1051: IF g_currentUIAction 1052: g_currentUIAction := g_currentUIAction+1;
1053: ELSE
1054: SELECT CZ_UI_ACTIONS_S.nextval INTO g_currUIActionSeqVal FROM dual;

Line 1054: SELECT CZ_UI_ACTIONS_S.nextval INTO g_currUIActionSeqVal FROM dual;

1050: ELSIF p_sequence_name='CZ_UI_ACTIONS_S' THEN
1051: IF g_currentUIAction 1052: g_currentUIAction := g_currentUIAction+1;
1053: ELSE
1054: SELECT CZ_UI_ACTIONS_S.nextval INTO g_currUIActionSeqVal FROM dual;
1055: g_currentUIAction := g_currUIActionSeqVal;
1056: END IF;
1057: RETURN g_currentUIAction;
1058: ELSIF p_sequence_name='CZ_INTL_TEXTS_S' THEN

Line 1926: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;

1922: -- get UI Action Id associated with a given ui node
1923: --
1924: FUNCTION get_UI_Action_Id(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
1925: RETURN NUMBER IS
1926: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
1927: BEGIN
1928: SELECT ui_action_id
1929: INTO l_ui_action_id
1930: FROM CZ_UI_ACTIONS

Line 1930: FROM CZ_UI_ACTIONS

1926: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
1927: BEGIN
1928: SELECT ui_action_id
1929: INTO l_ui_action_id
1930: FROM CZ_UI_ACTIONS
1931: WHERE ui_def_id = p_ui_node.ui_def_id AND
1932: source_page_id=p_ui_node.page_id AND
1933: element_id = p_ui_node.element_id AND
1934: deleted_flag=G_NO_FLAG;

Line 3294: FROM CZ_UI_ACTIONS

3290:
3291: BEGIN
3292: SELECT cx_command_name
3293: INTO l_ui_cx_command_name
3294: FROM CZ_UI_ACTIONS
3295: WHERE ui_def_id=p_ui_node.ui_def_id AND
3296: element_id=p_ui_node.element_id AND
3297: cx_command_name IS NOT NULL AND-- fix for bug 3923033
3298: deleted_flag=G_NO_FLAG;

Line 3630: FROM CZ_UI_ACTIONS

3626: g_ui_refs_tbl(i.ref_persistent_node_id) := i.ref_persistent_node_id;
3627: END LOOP;
3628:
3629: FOR i IN (SELECT element_id, ui_action_id
3630: FROM CZ_UI_ACTIONS
3631: WHERE ui_def_id = g_UI_Context.ui_def_id AND
3632: deleted_flag = G_NO_FLAG)
3633: LOOP
3634: BEGIN

Line 5655: l_new_target_node_path CZ_UI_ACTIONS.target_node_path%TYPE;

5651: l_persistent_rule_id NUMBER;
5652: l_new_intl_text_id NUMBER;
5653: l_ui_def_node CZ_UI_DEFS%ROWTYPE;
5654: l_prev_ui_context CZ_UI_DEFS%ROWTYPE;
5655: l_new_target_node_path CZ_UI_ACTIONS.target_node_path%TYPE;
5656: l_base_persistent_node_id NUMBER;
5657: l_base_expl_node_id NUMBER;
5658: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
5659: l_component_id NUMBER;

Line 5684: FOR i IN(SELECT * FROM CZ_UI_ACTIONS

5680: END;
5681:
5682: IF l_id IS NOT NULL THEN
5683:
5684: FOR i IN(SELECT * FROM CZ_UI_ACTIONS
5685: WHERE ui_def_id=p_source_ui_def_id AND
5686: ui_action_id=l_id AND
5687: NVL(source_page_id,0)=NVL(p_source_ui_page_id,0)
5688: AND seeded_flag=G_NO_FLAG)

Line 5691: l_new_action_id := allocateId('CZ_UI_ACTIONS_S');

5687: NVL(source_page_id,0)=NVL(p_source_ui_page_id,0)
5688: AND seeded_flag=G_NO_FLAG)
5689: LOOP
5690:
5691: l_new_action_id := allocateId('CZ_UI_ACTIONS_S');
5692:
5693: IF i.target_persistent_node_id IS NOT NULL THEN
5694: -- If the IL AMN is passed in, then use that else use the AMN on the page. IL AMN will be passed
5695: -- when the caller needs the paths in actions to start from a node different

Line 5720: INSERT INTO CZ_UI_ACTIONS

5716: ELSE
5717: l_new_target_node_path := NULL;
5718: END IF;
5719:
5720: INSERT INTO CZ_UI_ACTIONS
5721: (
5722: UI_ACTION_ID
5723: ,UI_DEF_ID
5724: ,SOURCE_PAGE_ID

Line 6025: FOR i IN(SELECT * FROM CZ_UI_ACTIONS

6021: END;
6022:
6023: IF l_id IS NOT NULL THEN
6024:
6025: FOR i IN(SELECT * FROM CZ_UI_ACTIONS
6026: WHERE ui_action_id=l_id AND
6027: ui_def_id=p_source_ui_def_id AND
6028: source_page_id=0 AND
6029: seeded_flag=G_NO_FLAG)

Line 6032: l_new_action_id := allocateId('CZ_UI_ACTIONS_S');

6028: source_page_id=0 AND
6029: seeded_flag=G_NO_FLAG)
6030: LOOP
6031:
6032: l_new_action_id := allocateId('CZ_UI_ACTIONS_S');
6033:
6034: INSERT INTO CZ_UI_ACTIONS
6035: (
6036: UI_ACTION_ID

Line 6034: INSERT INTO CZ_UI_ACTIONS

6030: LOOP
6031:
6032: l_new_action_id := allocateId('CZ_UI_ACTIONS_S');
6033:
6034: INSERT INTO CZ_UI_ACTIONS
6035: (
6036: UI_ACTION_ID
6037: ,UI_DEF_ID
6038: ,SOURCE_PAGE_ID

Line 8519: FOR i IN(SELECT target_persistent_node_id,target_expl_node_id FROM CZ_UI_ACTIONS

8515: l_ui_action_id := NULL;
8516: END;
8517:
8518: IF l_ui_action_id IS NOT NULL THEN
8519: FOR i IN(SELECT target_persistent_node_id,target_expl_node_id FROM CZ_UI_ACTIONS
8520: WHERE ui_def_id=g_UI_Context.ui_def_id AND
8521: source_page_id=p_ui_page_id AND
8522: element_id=p_ui_element_id AND
8523: target_node_path IS NOT NULL AND

Line 8532: UPDATE CZ_UI_ACTIONS

8528: p_base_expl_id => p_base_expl_id,
8529: p_persistent_node_id => i.target_persistent_node_id,
8530: p_ui_node_expl_id => i.target_expl_node_id);
8531: IF l_new_model_path IS NOT NULL THEN
8532: UPDATE CZ_UI_ACTIONS
8533: SET target_node_path=l_new_model_path
8534: WHERE ui_def_id=g_UI_Context.ui_def_id AND
8535: source_page_id=p_ui_page_id AND
8536: element_id=p_ui_element_id AND

Line 9430: FOR k IN(SELECT ui_action_id FROM CZ_UI_ACTIONS

9426: persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
9427: WHERE ps_node_id=p_component_id)
9428: AND deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE))
9429: LOOP
9430: FOR k IN(SELECT ui_action_id FROM CZ_UI_ACTIONS
9431: WHERE ui_def_id=g_UI_Context.ui_def_id AND element_id=i.element_id AND
9432: cx_command_name=p_command_name AND deleted_flag=G_NO_FLAG)
9433: LOOP
9434: RETURN i.element_id;

Line 9449: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;

9445: p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
9446:
9447: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9448: l_parent_element_id CZ_UI_PAGE_ELEMENTS.parent_element_id%TYPE;
9449: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
9450: l_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
9451: l_page_path VARCHAR2(32000);
9452: l_ui_intl_text_id INTEGER;
9453: l_counter INTEGER;

Line 9578: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');

9574: g_DRILLDOWN_B_SIGNATURE_ID,
9575: l_name,
9576: G_MARK_TO_ADD);
9577:
9578: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');
9579:
9580: INSERT INTO CZ_UI_ACTIONS
9581: (
9582: ui_action_id

Line 9580: INSERT INTO CZ_UI_ACTIONS

9576: G_MARK_TO_ADD);
9577:
9578: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');
9579:
9580: INSERT INTO CZ_UI_ACTIONS
9581: (
9582: ui_action_id
9583: ,ui_def_id
9584: ,source_page_id

Line 9751: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');

9747: g_DRILLDOWN_B_SIGNATURE_ID,
9748: 'Button - '||i.data_value,
9749: G_MARK_TO_ADD);
9750:
9751: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');
9752:
9753: INSERT INTO CZ_UI_ACTIONS
9754: (
9755: ui_action_id

Line 9753: INSERT INTO CZ_UI_ACTIONS

9749: G_MARK_TO_ADD);
9750:
9751: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');
9752:
9753: INSERT INTO CZ_UI_ACTIONS
9754: (
9755: ui_action_id
9756: ,ui_def_id
9757: ,source_page_id

Line 9858: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;

9854:
9855: l_ui_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;
9856: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9857: l_parent_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9858: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
9859: l_persistent_intl_text_id NUMBER;
9860: BEGIN
9861:
9862: FOR option_node IN(SELECT ps_node_id,persistent_node_id,

Line 9972: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');

9968: g_DRILLDOWN_B_SIGNATURE_ID,
9969: G_DRILLDOWN_TEMPLATE_NAME||' - '||l_element_id,
9970: G_MARK_TO_ADD);
9971:
9972: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');
9973:
9974: INSERT INTO CZ_UI_ACTIONS
9975: (
9976: ui_action_id

Line 9974: INSERT INTO CZ_UI_ACTIONS

9970: G_MARK_TO_ADD);
9971:
9972: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');
9973:
9974: INSERT INTO CZ_UI_ACTIONS
9975: (
9976: ui_action_id
9977: ,ui_def_id
9978: ,source_page_id

Line 10069: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;

10065:
10066: l_ui_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;
10067: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10068: l_parent_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10069: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
10070: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
10071: l_invalid_flag VARCHAR2(1);
10072:
10073: BEGIN

Line 10108: EXISTS (SELECT NULL FROM CZ_UI_ACTIONS a

10104: WHERE ui_def_id = g_UI_Context.ui_def_id AND
10105: persistent_node_id = i.persistent_node_id AND
10106: element_type = G_UI_CX_BUTTON_NODE_TYPE AND
10107: deleted_flag NOT IN (G_YES_FLAG, G_MARK_TO_DELETE) AND
10108: EXISTS (SELECT NULL FROM CZ_UI_ACTIONS a
10109: WHERE a.ui_def_id = e.ui_def_id AND
10110: a.source_page_id = e.page_id AND
10111: a.element_id = e.element_id AND
10112: a.deleted_flag NOT IN (G_YES_FLAG, G_MARK_TO_DELETE) AND

Line 10411: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;

10407: p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
10408: p_page_set_id IN NUMBER) IS
10409:
10410: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10411: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
10412: l_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
10413: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
10414:
10415: BEGIN

Line 10474: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');

10470: l_ui_node_name,
10471: g_DRILLDOWN_ELEM_SIGNATURE_ID,
10472: G_MARK_TO_ADD);
10473:
10474: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');
10475: INSERT INTO CZ_UI_ACTIONS
10476: (ui_action_id,
10477: ui_def_id,
10478: source_page_id,

Line 10475: INSERT INTO CZ_UI_ACTIONS

10471: g_DRILLDOWN_ELEM_SIGNATURE_ID,
10472: G_MARK_TO_ADD);
10473:
10474: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');
10475: INSERT INTO CZ_UI_ACTIONS
10476: (ui_action_id,
10477: ui_def_id,
10478: source_page_id,
10479: context_component_id,

Line 11347: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;

11343: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
11344: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
11345: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
11346: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
11347: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
11348: l_max_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
11349: l_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
11350: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
11351: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

Line 11540: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');

11536: WHEN OTHERS THEN
11537: NULL;
11538: END;
11539:
11540: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');
11541: INSERT INTO CZ_UI_ACTIONS
11542: (ui_action_id,
11543: ui_def_id,
11544: source_page_id,

Line 11541: INSERT INTO CZ_UI_ACTIONS

11537: NULL;
11538: END;
11539:
11540: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');
11541: INSERT INTO CZ_UI_ACTIONS
11542: (ui_action_id,
11543: ui_def_id,
11544: source_page_id,
11545: context_component_id,

Line 11987: UPDATE CZ_UI_ACTIONS

11983: page_id = p_ui_node.page_id AND
11984: element_id = l_element_id_tbl(i);
11985: END IF;
11986:
11987: UPDATE CZ_UI_ACTIONS
11988: SET deleted_flag=G_YES_FLAG
11989: WHERE ui_def_id=p_ui_node.ui_def_id AND
11990: source_page_id=p_ui_node.page_id AND
11991: element_id=l_element_id_tbl(i);

Line 13498: UPDATE CZ_UI_ACTIONS

13494: page_id = p_ui_page_node.page_id AND
13495: element_id = TO_CHAR(l_current_element_id);
13496: END IF;
13497:
13498: UPDATE CZ_UI_ACTIONS
13499: SET source_page_id=p_elements_tbl(l_current_element_id).page_id
13500: WHERE ui_def_id=p_ui_page_node.ui_def_id AND
13501: source_page_id= p_ui_page_node.page_id AND
13502: element_id=TO_CHAR(l_current_element_id);

Line 15843: UPDATE CZ_UI_ACTIONS

15839: WHERE ui_def_id=g_UI_Context.ui_def_id AND
15840: target_persistent_node_id=t.psnode_persistent_node_id AND
15841: target_expl_node_id<>l_expl_id;
15842:
15843: UPDATE CZ_UI_ACTIONS
15844: SET target_expl_node_id=l_expl_id
15845: WHERE ui_def_id=g_UI_Context.ui_def_id AND
15846: target_persistent_node_id=t.psnode_persistent_node_id AND
15847: target_expl_node_id<>l_expl_id;

Line 17524: -- cz_ui_page_refs, cz_ui_page_sets , cz_ui_actions with cz_model_ref_Expls table.

17520: NULL;
17521: END log_message;
17522:
17523: --bug14029835 , Added procedure that checks the data in cz_ui_page_elements, cz_ui_pages
17524: -- cz_ui_page_refs, cz_ui_page_sets , cz_ui_actions with cz_model_ref_Expls table.
17525: -- Logically deletes the invalid elements.
17526: PROCEDURE delete_Invalid_UI_Elements(p_ui_def_id IN NUMBER) IS
17527:
17528: BEGIN

Line 17620: -- Verify for cz_ui_actions.target_expl_node_id

17616:
17617: END LOOP; --uiPges
17618:
17619:
17620: -- Verify for cz_ui_actions.target_expl_node_id
17621: FOR uiActs IN (SELECT uiact.ui_action_id,uiact.target_expl_node_id FROM CZ_UI_ACTIONS uiact
17622: WHERE uiact.deleted_flag = G_NO_FLAG AND uiact.ui_def_id = uiDefCur.ref_ui_def_id
17623: AND uiact.target_expl_node_id IS NOT NULL
17624: AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS

Line 17621: FOR uiActs IN (SELECT uiact.ui_action_id,uiact.target_expl_node_id FROM CZ_UI_ACTIONS uiact

17617: END LOOP; --uiPges
17618:
17619:
17620: -- Verify for cz_ui_actions.target_expl_node_id
17621: FOR uiActs IN (SELECT uiact.ui_action_id,uiact.target_expl_node_id FROM CZ_UI_ACTIONS uiact
17622: WHERE uiact.deleted_flag = G_NO_FLAG AND uiact.ui_def_id = uiDefCur.ref_ui_def_id
17623: AND uiact.target_expl_node_id IS NOT NULL
17624: AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS
17625: WHERE deleted_flag = G_NO_FLAG AND model_ref_expl_id = uiact.target_expl_node_id

Line 17631: log_message( 'UI_REFRESH' , 'UPDATE deleted_flag of CZ_UI_ACTIONS where target_expl_node_id : ' || uiActs.target_expl_node_id || ' and ui_def_id : '|| uiDefCur.ref_ui_def_id);

17627: )
17628: LOOP
17629:
17630:
17631: log_message( 'UI_REFRESH' , 'UPDATE deleted_flag of CZ_UI_ACTIONS where target_expl_node_id : ' || uiActs.target_expl_node_id || ' and ui_def_id : '|| uiDefCur.ref_ui_def_id);
17632:
17633: UPDATE CZ_UI_ACTIONS
17634: SET deleted_flag = G_YES_FLAG
17635: WHERE target_expl_node_id = uiActs.target_expl_node_id

Line 17633: UPDATE CZ_UI_ACTIONS

17629:
17630:
17631: log_message( 'UI_REFRESH' , 'UPDATE deleted_flag of CZ_UI_ACTIONS where target_expl_node_id : ' || uiActs.target_expl_node_id || ' and ui_def_id : '|| uiDefCur.ref_ui_def_id);
17632:
17633: UPDATE CZ_UI_ACTIONS
17634: SET deleted_flag = G_YES_FLAG
17635: WHERE target_expl_node_id = uiActs.target_expl_node_id
17636: AND ui_action_id = uiActs.ui_action_id
17637: AND ui_def_id = uiDefCur.ref_ui_def_id;

Line 17753: UPDATE CZ_UI_ACTIONS

17749: IF l_user_attribute_value IS NOT NULL THEN
17750:
17751: l_persistent_id := TO_NUMBER(get_User_Attribute(l_user_attribute_value,'actionId'));
17752: IF l_persistent_id IS NOT NULL THEN
17753: UPDATE CZ_UI_ACTIONS
17754: SET deleted_flag=G_YES_FLAG
17755: WHERE ui_def_id=p_ui_def_id AND
17756: ui_action_id=l_persistent_id AND
17757: seeded_flag=G_NO_FLAG;

Line 18849: UPDATE CZ_UI_ACTIONS

18845:
18846: END IF;
18847:
18848: FORALL i IN l_element_id_tbl.First..l_element_id_tbl.Last
18849: UPDATE CZ_UI_ACTIONS
18850: SET deleted_flag=G_YES_FLAG
18851: WHERE ui_def_id=p_ui_def_id AND
18852: source_page_id=p_ui_page_id AND
18853: element_id=l_element_id_tbl(i) AND deleted_flag=G_NO_FLAG AND seeded_flag=G_NO_FLAG;

Line 21929: g_UIActionINCREMENT := get_Seq_Inc('CZ_UI_ACTIONS_S', l_oracle_schema);

21925: g_UINodeINCREMENT := get_Seq_Inc('CZ_UI_PAGE_ELEMENTS_S', l_oracle_schema);
21926: g_PageRefINCREMENT := get_Seq_Inc('CZ_UI_PAGE_REFS_S', l_oracle_schema);
21927: g_PageINCREMENT := get_Seq_Inc('CZ_UI_PAGES_S', l_oracle_schema);
21928: g_PageSetINCREMENT := get_Seq_Inc('CZ_UI_PAGE_SETS_S', l_oracle_schema);
21929: g_UIActionINCREMENT := get_Seq_Inc('CZ_UI_ACTIONS_S', l_oracle_schema);
21930:
21931: SELECT template_name
21932: INTO G_DRILLDOWN_TEMPLATE_NAME
21933: FROM CZ_UI_TEMPLATES