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 732: SELECT CZ_UI_ACTIONS_S.nextval INTO g_currentUIAction FROM dual;

728:
729: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currentPageSet FROM dual;
730: g_currPageSetSeqVal := g_currentPageSet;
731:
732: SELECT CZ_UI_ACTIONS_S.nextval INTO g_currentUIAction FROM dual;
733: g_currUIActionSeqVal := g_currentUIAction;
734:
735: END Initialize_Sequences;
736:

Line 1044: ELSIF p_sequence_name='CZ_UI_ACTIONS_S' THEN

1040: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currPageSetSeqVal FROM dual;
1041: g_currentPageSet := g_currPageSetSeqVal;
1042: END IF;
1043: RETURN g_currentPageSet;
1044: ELSIF p_sequence_name='CZ_UI_ACTIONS_S' THEN
1045: IF g_currentUIAction 1046: g_currentUIAction := g_currentUIAction+1;
1047: ELSE
1048: SELECT CZ_UI_ACTIONS_S.nextval INTO g_currUIActionSeqVal FROM dual;

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

1044: ELSIF p_sequence_name='CZ_UI_ACTIONS_S' THEN
1045: IF g_currentUIAction 1046: g_currentUIAction := g_currentUIAction+1;
1047: ELSE
1048: SELECT CZ_UI_ACTIONS_S.nextval INTO g_currUIActionSeqVal FROM dual;
1049: g_currentUIAction := g_currUIActionSeqVal;
1050: END IF;
1051: RETURN g_currentUIAction;
1052: ELSIF p_sequence_name='CZ_INTL_TEXTS_S' THEN

Line 1871: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;

1867: -- get UI Action Id associated with a given ui node
1868: --
1869: FUNCTION get_UI_Action_Id(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
1870: RETURN NUMBER IS
1871: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
1872: BEGIN
1873: SELECT ui_action_id
1874: INTO l_ui_action_id
1875: FROM CZ_UI_ACTIONS

Line 1875: FROM CZ_UI_ACTIONS

1871: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
1872: BEGIN
1873: SELECT ui_action_id
1874: INTO l_ui_action_id
1875: FROM CZ_UI_ACTIONS
1876: WHERE ui_def_id = p_ui_node.ui_def_id AND
1877: source_page_id=p_ui_node.page_id AND
1878: element_id = p_ui_node.element_id AND
1879: deleted_flag=G_NO_FLAG;

Line 3232: FROM CZ_UI_ACTIONS

3228:
3229: BEGIN
3230: SELECT cx_command_name
3231: INTO l_ui_cx_command_name
3232: FROM CZ_UI_ACTIONS
3233: WHERE ui_def_id=p_ui_node.ui_def_id AND
3234: element_id=p_ui_node.element_id AND
3235: cx_command_name IS NOT NULL AND-- fix for bug 3923033
3236: deleted_flag=G_NO_FLAG;

Line 3568: FROM CZ_UI_ACTIONS

3564: g_ui_refs_tbl(i.ref_persistent_node_id) := i.ref_persistent_node_id;
3565: END LOOP;
3566:
3567: FOR i IN (SELECT element_id, ui_action_id
3568: FROM CZ_UI_ACTIONS
3569: WHERE ui_def_id = g_UI_Context.ui_def_id AND
3570: deleted_flag = G_NO_FLAG)
3571: LOOP
3572: BEGIN

Line 5475: l_new_target_node_path CZ_UI_ACTIONS.target_node_path%TYPE;

5471: l_new_rule_id NUMBER;
5472: l_new_intl_text_id NUMBER;
5473: l_ui_def_node CZ_UI_DEFS%ROWTYPE;
5474: l_prev_ui_context CZ_UI_DEFS%ROWTYPE;
5475: l_new_target_node_path CZ_UI_ACTIONS.target_node_path%TYPE;
5476:
5477: BEGIN
5478:
5479: IF px_user_attribute_value IS NULL THEN

Line 5497: FOR i IN(SELECT * FROM CZ_UI_ACTIONS

5493: END;
5494:
5495: IF l_id IS NOT NULL THEN
5496:
5497: FOR i IN(SELECT * FROM CZ_UI_ACTIONS
5498: WHERE ui_def_id=p_source_ui_def_id AND
5499: ui_action_id=l_id AND
5500: NVL(source_page_id,0)=NVL(p_source_ui_page_id,0)
5501: AND seeded_flag=G_NO_FLAG)

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

5500: NVL(source_page_id,0)=NVL(p_source_ui_page_id,0)
5501: AND seeded_flag=G_NO_FLAG)
5502: LOOP
5503:
5504: l_new_action_id := allocateId('CZ_UI_ACTIONS_S');
5505:
5506: IF i.target_persistent_node_id IS NOT NULL THEN
5507: l_new_target_node_path := get_Runtime_Relative_Path(p_model_id => l_ui_def_node.devl_project_id,
5508: p_persistent_node_id => i.target_persistent_node_id,

Line 5514: INSERT INTO CZ_UI_ACTIONS

5510: ELSE
5511: l_new_target_node_path := NULL;
5512: END IF;
5513:
5514: INSERT INTO CZ_UI_ACTIONS
5515: (
5516: UI_ACTION_ID
5517: ,UI_DEF_ID
5518: ,SOURCE_PAGE_ID

Line 5782: FOR i IN(SELECT * FROM CZ_UI_ACTIONS

5778: END;
5779:
5780: IF l_id IS NOT NULL THEN
5781:
5782: FOR i IN(SELECT * FROM CZ_UI_ACTIONS
5783: WHERE ui_action_id=l_id AND
5784: ui_def_id=p_source_ui_def_id AND
5785: source_page_id=0 AND
5786: seeded_flag=G_NO_FLAG)

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

5785: source_page_id=0 AND
5786: seeded_flag=G_NO_FLAG)
5787: LOOP
5788:
5789: l_new_action_id := allocateId('CZ_UI_ACTIONS_S');
5790:
5791: INSERT INTO CZ_UI_ACTIONS
5792: (
5793: UI_ACTION_ID

Line 5791: INSERT INTO CZ_UI_ACTIONS

5787: LOOP
5788:
5789: l_new_action_id := allocateId('CZ_UI_ACTIONS_S');
5790:
5791: INSERT INTO CZ_UI_ACTIONS
5792: (
5793: UI_ACTION_ID
5794: ,UI_DEF_ID
5795: ,SOURCE_PAGE_ID

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

8166: l_ui_action_id := NULL;
8167: END;
8168:
8169: IF l_ui_action_id IS NOT NULL THEN
8170: FOR i IN(SELECT target_persistent_node_id,target_expl_node_id FROM CZ_UI_ACTIONS
8171: WHERE ui_def_id=g_UI_Context.ui_def_id AND
8172: source_page_id=p_ui_page_id AND
8173: element_id=p_ui_element_id AND
8174: target_node_path IS NOT NULL AND

Line 8183: UPDATE CZ_UI_ACTIONS

8179: p_page_id => p_ui_page_id,
8180: p_ui_node_expl_id => i.target_expl_node_id);
8181:
8182: IF l_new_model_path IS NOT NULL THEN
8183: UPDATE CZ_UI_ACTIONS
8184: SET target_node_path=l_new_model_path
8185: WHERE ui_def_id=g_UI_Context.ui_def_id AND
8186: source_page_id=p_ui_page_id AND
8187: element_id=p_ui_element_id AND

Line 8970: FOR k IN(SELECT ui_action_id FROM CZ_UI_ACTIONS

8966: persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
8967: WHERE ps_node_id=p_component_id)
8968: AND deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE))
8969: LOOP
8970: FOR k IN(SELECT ui_action_id FROM CZ_UI_ACTIONS
8971: WHERE ui_def_id=g_UI_Context.ui_def_id AND element_id=i.element_id AND
8972: cx_command_name=p_command_name AND deleted_flag=G_NO_FLAG)
8973: LOOP
8974: RETURN i.element_id;

Line 8989: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;

8985: p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
8986:
8987: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
8988: l_parent_element_id CZ_UI_PAGE_ELEMENTS.parent_element_id%TYPE;
8989: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
8990: l_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
8991: l_page_path VARCHAR2(32000);
8992: l_ui_intl_text_id INTEGER;
8993: l_counter INTEGER;

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

9109: g_DRILLDOWN_B_SIGNATURE_ID,
9110: l_name,
9111: G_MARK_TO_ADD);
9112:
9113: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');
9114:
9115: INSERT INTO CZ_UI_ACTIONS
9116: (
9117: ui_action_id

Line 9115: INSERT INTO CZ_UI_ACTIONS

9111: G_MARK_TO_ADD);
9112:
9113: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');
9114:
9115: INSERT INTO CZ_UI_ACTIONS
9116: (
9117: ui_action_id
9118: ,ui_def_id
9119: ,source_page_id

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

9277: g_DRILLDOWN_B_SIGNATURE_ID,
9278: 'Button - '||i.data_value,
9279: G_MARK_TO_ADD);
9280:
9281: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');
9282:
9283: INSERT INTO CZ_UI_ACTIONS
9284: (
9285: ui_action_id

Line 9283: INSERT INTO CZ_UI_ACTIONS

9279: G_MARK_TO_ADD);
9280:
9281: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');
9282:
9283: INSERT INTO CZ_UI_ACTIONS
9284: (
9285: ui_action_id
9286: ,ui_def_id
9287: ,source_page_id

Line 9388: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;

9384:
9385: l_ui_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;
9386: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9387: l_parent_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9388: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
9389:
9390: BEGIN
9391:
9392: FOR option_node IN(SELECT ps_node_id,persistent_node_id,

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

9494: g_DRILLDOWN_B_SIGNATURE_ID,
9495: G_DRILLDOWN_TEMPLATE_NAME||' - '||l_element_id,
9496: G_MARK_TO_ADD);
9497:
9498: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');
9499:
9500: INSERT INTO CZ_UI_ACTIONS
9501: (
9502: ui_action_id

Line 9500: INSERT INTO CZ_UI_ACTIONS

9496: G_MARK_TO_ADD);
9497:
9498: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');
9499:
9500: INSERT INTO CZ_UI_ACTIONS
9501: (
9502: ui_action_id
9503: ,ui_def_id
9504: ,source_page_id

Line 9595: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;

9591:
9592: l_ui_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;
9593: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9594: l_parent_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9595: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
9596: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
9597: l_invalid_flag VARCHAR2(1);
9598:
9599: BEGIN

Line 9634: EXISTS (SELECT NULL FROM CZ_UI_ACTIONS a

9630: WHERE ui_def_id = g_UI_Context.ui_def_id AND
9631: persistent_node_id = i.persistent_node_id AND
9632: element_type = G_UI_CX_BUTTON_NODE_TYPE AND
9633: deleted_flag NOT IN (G_YES_FLAG, G_MARK_TO_DELETE) AND
9634: EXISTS (SELECT NULL FROM CZ_UI_ACTIONS a
9635: WHERE a.ui_def_id = e.ui_def_id AND
9636: a.source_page_id = e.page_id AND
9637: a.element_id = e.element_id AND
9638: a.deleted_flag NOT IN (G_YES_FLAG, G_MARK_TO_DELETE) AND

Line 9937: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;

9933: p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
9934: p_page_set_id IN NUMBER) IS
9935:
9936: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9937: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
9938: l_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
9939: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
9940:
9941: BEGIN

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

9996: l_ui_node_name,
9997: g_DRILLDOWN_ELEM_SIGNATURE_ID,
9998: G_MARK_TO_ADD);
9999:
10000: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');
10001: INSERT INTO CZ_UI_ACTIONS
10002: (ui_action_id,
10003: ui_def_id,
10004: source_page_id,

Line 10001: INSERT INTO CZ_UI_ACTIONS

9997: g_DRILLDOWN_ELEM_SIGNATURE_ID,
9998: G_MARK_TO_ADD);
9999:
10000: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');
10001: INSERT INTO CZ_UI_ACTIONS
10002: (ui_action_id,
10003: ui_def_id,
10004: source_page_id,
10005: context_component_id,

Line 10868: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;

10864: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
10865: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
10866: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
10867: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
10868: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
10869: l_max_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
10870: l_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
10871: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
10872: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

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

11057: WHEN OTHERS THEN
11058: NULL;
11059: END;
11060:
11061: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');
11062: INSERT INTO CZ_UI_ACTIONS
11063: (ui_action_id,
11064: ui_def_id,
11065: source_page_id,

Line 11062: INSERT INTO CZ_UI_ACTIONS

11058: NULL;
11059: END;
11060:
11061: l_ui_action_id := allocateId('CZ_UI_ACTIONS_S');
11062: INSERT INTO CZ_UI_ACTIONS
11063: (ui_action_id,
11064: ui_def_id,
11065: source_page_id,
11066: context_component_id,

Line 11508: UPDATE CZ_UI_ACTIONS

11504: page_id = p_ui_node.page_id AND
11505: element_id = l_element_id_tbl(i);
11506: END IF;
11507:
11508: UPDATE CZ_UI_ACTIONS
11509: SET deleted_flag=G_YES_FLAG
11510: WHERE ui_def_id=p_ui_node.ui_def_id AND
11511: source_page_id=p_ui_node.page_id AND
11512: element_id=l_element_id_tbl(i);

Line 13014: UPDATE CZ_UI_ACTIONS

13010: page_id = p_ui_page_node.page_id AND
13011: element_id = TO_CHAR(l_current_element_id);
13012: END IF;
13013:
13014: UPDATE CZ_UI_ACTIONS
13015: SET source_page_id=p_elements_tbl(l_current_element_id).page_id
13016: WHERE ui_def_id=p_ui_page_node.ui_def_id AND
13017: source_page_id= p_ui_page_node.page_id AND
13018: element_id=TO_CHAR(l_current_element_id);

Line 16903: UPDATE CZ_UI_ACTIONS

16899: IF l_user_attribute_value IS NOT NULL THEN
16900:
16901: l_persistent_id := TO_NUMBER(get_User_Attribute(l_user_attribute_value,'actionId'));
16902: IF l_persistent_id IS NOT NULL THEN
16903: UPDATE CZ_UI_ACTIONS
16904: SET deleted_flag=G_YES_FLAG
16905: WHERE ui_def_id=p_ui_def_id AND
16906: ui_action_id=l_persistent_id AND
16907: seeded_flag=G_NO_FLAG;

Line 17943: UPDATE CZ_UI_ACTIONS

17939:
17940: END IF;
17941:
17942: FORALL i IN l_element_id_tbl.First..l_element_id_tbl.Last
17943: UPDATE CZ_UI_ACTIONS
17944: SET deleted_flag=G_YES_FLAG
17945: WHERE ui_def_id=p_ui_def_id AND
17946: source_page_id=p_ui_page_id AND
17947: element_id=l_element_id_tbl(i) AND deleted_flag=G_NO_FLAG AND seeded_flag=G_NO_FLAG;

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

20809: g_UINodeINCREMENT := get_Seq_Inc('CZ_UI_PAGE_ELEMENTS_S', l_oracle_schema);
20810: g_PageRefINCREMENT := get_Seq_Inc('CZ_UI_PAGE_REFS_S', l_oracle_schema);
20811: g_PageINCREMENT := get_Seq_Inc('CZ_UI_PAGES_S', l_oracle_schema);
20812: g_PageSetINCREMENT := get_Seq_Inc('CZ_UI_PAGE_SETS_S', l_oracle_schema);
20813: g_UIActionINCREMENT := get_Seq_Inc('CZ_UI_ACTIONS_S', l_oracle_schema);
20814:
20815: SELECT template_name
20816: INTO G_DRILLDOWN_TEMPLATE_NAME
20817: FROM CZ_UI_TEMPLATES