34: AND object_name = p_pubitem
35: ;
36:
37: BEGIN
38: x_return_status := FND_API.G_RET_STS_ERROR;
39:
40: /** initialize tables **/
41: l_all_pubitems_tbl := l_null_pubitems_tbl;
42: x_pubitems_tbl := l_null_pubitems_tbl;
48: l_all_pubitems_tbl,
49: l_return_status);
50:
51: /*** successfully retrieved item names? ***/
52: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_all_pubitems_tbl.COUNT = 0 THEN
53: NULL;
54: ELSE
55: l_defer_count := 0;
56: FOR i IN 1..l_all_pubitems_tbl.count LOOP
63: CLOSE c_isdeferred;
64: END LOOP;
65: END IF;
66:
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: END GET_ALL_DEFERRED_PUB_ITEMS;
70:
71:
122: ) IS
123: l_index BINARY_INTEGER;
124: BEGIN
125:
126: x_return_status := FND_API.G_RET_STS_SUCCESS;
127:
128: /*** call appropriate wrapper ***/
129:
130: /*** process Deferred first***/
447: -- logm('Dirty Pub items for tranid: ' || p_tranid || ' : ' || l_pubitems_tbl(i));
448: END LOOP;
449:
450: /*** successfully retrieved item names? ***/
451: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_pubitems_tbl.COUNT = 0 THEN
452: NULL;
453: ELSE
454: /*** yes -> process them ***/
455:
470: l_return_status);
471:
472:
473:
474: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_pubitems_tbl.COUNT = 0 THEN
475: NULL;
476: ELSE
477:
478: